Test data for opaque type support routines

To enter test data for an opaque type support routine, select the routine and choose Edit > Gather Test Data.

For opaque type support routines, each test data item includes the following elements:
Table 1. Test data for opaque type support routines
Test data item What to test for
An input value for the data type This value must be in the format specified for the text input routine.
The expected output value for the input value This value must be in the format specified for the text output routine of the type.
An error code, if the input value is not valid Leave this entry blank when the input value is expected to be correct.

Enter values to test the opaque type boundaries. For example, if a type does not accept negative input values, enter test data with negative values and specify the error code you expect to receive from the text input routine.

The data you enter for an opaque type is used to test all of the supporting routines defined for the type. BladeSmith generates SQL scripts to test each supporting routine, including the text input and output routines and other routines, such as binary input and output routines and comparison routines. Add test data values that thoroughly test each of these routines.