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

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-2385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16002470#comment-16002470 ] 

ASF GitHub Bot commented on TRAFODION-2385:
-------------------------------------------

GitHub user mashengchen opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/1088

    TRAFODION-2385 jdbcT4 support boolean, tinyint, largeint

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/mashengchen/incubator-trafodion jdbc_type_btl

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/1088.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1088
    
----
commit 3e4b74cdd3965fe68affe1025cb7090513e64d27
Author: mashengchen <ma...@gmail.com>
Date:   2017-05-09T10:42:32Z

    TRAFODION-2385 jdbcT4 support boolean, tinyint, largeint

----


> 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
>             Fix For: 2.1-incubating
>
>
> 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.15#6346)