Anoop Sharma created TRAFODION-2385:
Summary: Add support in clients for boolean, tinyint, largeint
Project: Apache Trafodion
Issue Type: New Feature
Reporter: Anoop Sharma
Support for new datatypes was added for tinyint, boolean, largeint unsigned in
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:
cqd traf_tinyint_return_values 'ON';
cqd traf_tinyint_input_params 'ON';
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.
This message was sent by Atlassian JIRA