[jira] [Created] (TRAFODION-2385) Add support in clients for boolean, tinyint, largeint unsigned datatypes

["Anoop Sharma (JIRA)" <ji...@apache.org>]

Anoop Sharma created TRAFODION-2385:
---------------------------------------

             Summary: Add support in clients for boolean, tinyint, largeint unsigned datatypes
                 Key: TRAFODION-2385
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2385
             Project: Apache Trafodion
          Issue Type: New Feature
          Components: connectivity-general
            Reporter: Anoop Sharma


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.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)