[teiid-issues] [JBoss JIRA] (TEIID-4715) Google translator allows to be inserted larger value than defined for teiid datatype

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-4715.
-----------------------------------
    Resolution: Rejected


The translator only fully supports double numeric columns.  Manually using the biginteger type may not behave as expected.

> Google translator allows to be inserted larger value than defined for teiid datatype
> ------------------------------------------------------------------------------------
>
>                 Key: TEIID-4715
>                 URL: https://issues.jboss.org/browse/TEIID-4715
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 9.2
>            Reporter: Lucie Fabrikova
>            Assignee: Steven Hawkins
>
> It is possible to insert larger value than defined by the teiid datatype, see query:
> INSERT INTO SmallA (IntKey, BigIntegerValue) VALUES (100, 1234567890123456789012345)
> But if I try to select the value, null is returned for BigIntegerValue:
> SELECT IntKey, BigIntegerValue FROM SmallA WHERE IntKey=100
> (VDB is same as in TEIID-4714)



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)