[teiid-issues] [JBoss JIRA] (TEIID-3502) Teiid returns number of type "byte" which ist out of range

[Steven Hawkins (JIRA)]

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

Steven Hawkins reopened TEIID-3502:
-----------------------------------


Since all of our logic is based upon the analogous java functions more often than not the default behavior will match java's.  In this case however you would expect an overflow exception.  A check would be needed for the int and long types.

> Teiid returns number of type "byte" which ist out of range
> ----------------------------------------------------------
>
>                 Key: TEIID-3502
>                 URL: https://issues.jboss.org/browse/TEIID-3502
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1.6_2
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>
> Teiid returns for query (1) a number which is out of range for type "byte" (2). The source column has the data type that is wider than byte (3), but e.g. Oracle does not support such small data type as byte so teiid should take care of it. Same with the data type "short".
> (1) SELECT bytenum, abs(bytenum) FROM <table>;
> (2)
> -128 128
> -127 127
> ...
> (3) oracle: bytenum - number
> teiid: bytenum - byte



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)