[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:comment-tabpanel&focusedCommentId=13387268#comment-13387268 ] 

Steven Hawkins commented on TEIID-4715:
---------------------------------------

More than likely it's the same situation.  Leave the type as double and repeat to confirm that the scenario works. 

> 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)