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.

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 should be 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.