[ https://issues.jboss.org/browse/TEIID-3502?page=com.atlassian.jira.plugin... ] 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. -- This message was sent by Atlassian JIRA (v6.3.15#6346)