Details
-
New Feature
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Support for new datatypes was added for tinyint, boolean, largeint unsigned in sql engine.
Those are tracked by following jiras:
JIRA TRAFODION-2086 Add support for largeint unsigned datatype
JIRA TRAFODION-2099 Add support for Boolean datatype
JIRA TRAFODION-2060 Add support for native tinyint datatype
Connectivity clients (odbc, jdbc t2/t4, linux, windows, trafci) need to
enhanced to add this support. There may also be some work needed
in mxosrvr layer. Until that is done, these datatypes cannot be used
for reading values or input params from these clients.
For now, these datatypes are converted to equivalent datatypes before input/output from clients.
To enable these datatypes, use these cqds:
For tinyint:
cqd traf_tinyint_return_values 'ON';
cqd traf_tinyint_input_params 'ON';
For boolean:
cqd traf_boolean_io 'ON';
For unsigned largeint:
cqd traf_largeint_unsigned_io 'ON';
These cqds are turned ON when request comes in from sqlci.
Once support for these datatypes is added to clients, they will be turned
on by default.
core/sql/regress/seabase/TEST003 contains examples of usage of these datatypes. First cut should be to make sure they work from trafci/jdbcT4.