[jira] [Commented] (TRAFODION-2060) Add support for native tinyint datatype

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

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

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

GitHub user anoopsharma00 opened a pull request:

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

    JIRA TRAFODION-2060  Add support for tinyint datatype

    -- added support for tinyint datatype to be used in create
       and cast statements
    -- added support for returning tinyint in select list and
       input params
    -- currently tinyint select list and input params is only enabled for
      queries from sqlci. Some support for it has been added to jdbc T4
      but need to be completed. Until then, tinyint select/param support
      is not enabled for t4/t2/odbc interfaces
    -- removed obsolete tandem floating point datatypes

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

    $ git pull https://github.com/anoopsharma00/incubator-trafodion ansharma_tinyint_br

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

    https://github.com/apache/incubator-trafodion/pull/545.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 #545
    
----
commit 88ec4feaaabcd2a609653e28496ed44ee9359ee3
Author: Anoop Sharma <an...@esgyn.com>
Date:   2016-06-14T19:14:32Z

    JIRA TRAFODION-2060  Add support for tinyint datatype
    
    -- added support for tinyint datatype to be used in create
       and cast statements
    -- added support for returning tinyint in select list and
       input params
    -- currently tinyint select list and input params is only enabled for
      queries from sqlci. Some support for it has been added to jdbc T4
      but need to be completed. Until then, tinyint select/param support
      is not enabled for t4/t2/odbc interfaces
    -- removed obsolete tandem floating point datatypes

----


> Add support for native tinyint datatype
> ---------------------------------------
>
>                 Key: TRAFODION-2060
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2060
>             Project: Apache Trafodion
>          Issue Type: Improvement
>            Reporter: Anoop Sharma
>            Assignee: Anoop Sharma
>            Priority: Minor
>
> Currently, tinyint datatype(1 byte integer) in trafodion is automatically converted to smallint (2 byte integer) and treated like smallint.
> It causes values that are beyond the tinyint range to be inserted
> and selected.
> Same issue happens with hive tinyint datatypes which are also
> treated as smallint. That causes inconsistent behavior when that
> datatype is accessed or inserted from hive vs. trafodion.
> This jira is to add support for true tinyint datatype in table definitions,
> cast stmts, param typing and handling of hive tables.



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