Opaque data type support routines tests
BladeSmith generates the following files in the project\functest\opaque\opaque directory
for every support routine for which you entered test data.
| File name | Description |
|---|---|
| binexp.sql | Tests binary file import/export functions for an opaque type; uses nested calls to the binary file import/export functions. The result of the nested calls is equivalent to the text input format for the type. |
| binio.sql | Tests binary file input/output functions; uses the valid input data for the opaque type. |
| btree.sql | Tests the B-tree index support routine. |
| cleanup.sql | Drops all of the test tables from the database. |
| compare.sql | Tests the SQL Compare() function. |
| concat.sql | Tests the concatenation operator; calls the SQL Concat() function for an opaque data type with two instances of the type. |
| contains.sql | Tests the SQL Contains() function. |
| divide.sql | Tests the SQL Divide() function. |
| equal.sql | Tests the SQL Equal() function. |
| greaterthan.sql | Tests the SQL GreaterThan() function. |
| greaterthanorequal.sql | Tests the SQL GreaterThanOrEqual() function. |
| hash.sql | Tests the SQL Hash() support function with a SELECT...GROUP BY SQL query. |
| inter.sql | Tests the SQL Inter() function. |
| lessthan.sql | Tests the SQL LessThan() function. |
| lessthanorequal.sql | Tests the SQL LessThanOrEqual() function. |
| main.sh | Executes the tests in this directory (.sh indicates this is a shell script). |
| minus.sql | Tests the SQL Minus() function. |
| negative.sql | Tests the SQL Negative() function. |
| notequal.sql | Tests the SQL NotEqual() function. |
| notify.sql | Tests the SQL Assign() and Destroy() routines; inserts and deletes values in a new test table. |
| overlap.sql | Tests the SQL Overlap() function. |
| plus.sql | Tests the SQL Plus() function. |
| positive.sql | Tests the SQL Positive() function. |
| setup.sql | Creates test tables and initializes them with test data. |
| size.sql | Tests the SQL Size() function. |
| textexp.sql | Tests text file import/export functions; uses the UNLOAD and LOAD SQL statements. |
| textio_neg.sql | Tests text input/output functions; uses test data with invalid input data. |
| textio_pos.sql | Tests text input/output functions; uses only valid test data. |
| times.sql | Tests the SQL Times() function. |
| union.sql | Tests the SQL Union() function. |
| within.sql | Tests the SQL Within() function. |