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

[Lucie Fabrikova (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13387085#comment-13387085 ] 

Lucie Fabrikova commented on TEIID-4715:
----------------------------------------

I observed similar issue with long, but inside teiid datatype range:
I inserted value 28341791043587382 to longnum column, and it was inserted into google spreadsheet correctly. But select returned null value.
If I select the value directly with google sheets api (e.g. ValueRange class) I get the inserted value.

Does the explanation ^ apply also to Long?

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