[
https://issues.jboss.org/browse/TEIID-3502?page=com.atlassian.jira.plugin...
]
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)