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

[Juraj Duráni (JIRA)]

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

Juraj Duráni updated TEIID-3502:
--------------------------------
    Affects Version/s: 8.7.1.6_2


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