[teiid-issues] [JBoss JIRA] (TEIID-3502) Teiid returns integer/long overflow values

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-3502:
----------------------------------
        Summary: Teiid returns integer/long overflow values  (was: Teiid returns number a negative abs value)
    Description: 
The values from basic math operations, such as:
SELECT abs(-2147483648)
SELECT -2147483648 -1
SELECT 2147483648 +1
etc.



  was:
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



Making the issue more general.

> Teiid returns integer/long overflow values
> ------------------------------------------
>
>                 Key: TEIID-3502
>                 URL: https://issues.jboss.org/browse/TEIID-3502
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.7.1.6_2
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> The values from basic math operations, such as:
> SELECT abs(-2147483648)
> SELECT -2147483648 -1
> SELECT 2147483648 +1
> etc.



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