[ https://issues.jboss.org/browse/TEIID-3141?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-3141: ------------------------------------- I have found these: SELECT intnum, ACOS(1 / intnum) FROM BQT1.SmallA WHERE intnum <> 0 ORDER BY intnum OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[Source.SmallA.IntNum, ACOS(convert((1 / Source.SmallA.IntNum), double))] SELECT g_0.IntNum AS c_0, ACOS(convert((1 / g_0.IntNum), double)) AS c_1 FROM Source.SmallA AS g_0 WHERE g_0.IntNum <> 0 ORDER BY c_0 LIMIT 100 *Return for almost every value 1.5708* (=ACOS(0)). Only rows with IntNum=1 and IntNum=-1 are correct. Same result for IntKey column. *But same result returns original sybaseDB* (maybe bug in sybase jdbc). I have tried oracle12 (VDB and original) and result has been OK. ---------------------------------------------------------------------------------------------------- SELECT longnum, ACOS(1 / longnum) FROM BQT1.SmallA WHERE longnum <> 0 ORDER BY longnum OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(0) output=[Source.SmallA.LongNum, ACOS(convert((1 / Source.SmallA.LongNum), bigdecimal))] SELECT g_0.LongNum AS c_0, ACOS(convert((1 / g_0.LongNum), bigdecimal)) AS c_1 FROM Source.SmallA AS g_0 WHERE g_0.LongNum <> 0 ORDER BY c_0 LIMIT 100 *Result is correct* (same for FloatNum, DoubleNum, BigIntegerValue, BigDecimalValue). IntNum and LongNum columns have same values so results should be same. ------------------------------------------------------------------------------------------------------- SELECT bytenum, ACOS(1 / bytenum) FROM BQT1.SmallA WHERE bytenum <> 0 ORDER BY bytenum *Result is for every value in the table 1.5708* (same for ShortValue). In this case *original sybase returns correct result*. ------------------------------------------------------------------------------------------------------- SELECT AVG(shortvalue) FROM BQT1.SmallA SELECT AVG(bytenum) FROM BQT1.SmallA *AVG returns integer* (-103/ByteNum, -32,743/ShortValue) but *should be real* (-103.2766/ByteNum, -32,743.65957/ShortValue). *Original sybase DB returns correct result* in this case. AVG with DoubleNum, LongNum, BigIntegerNum, BigDecimalNum, IntKey, IntNum, FloatNum returns correct result. ------------------------------------------------------------------------------------------------------ -- This message was sent by Atlassian JIRA (v6.3.1#6329)