]
RH Bugzilla Integration updated TEIID-3388:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References:
Different null ordering for float and double numbers with RADIANS
function (Oracle 12)
--------------------------------------------------------------------------------------
Key: TEIID-3388
URL:
https://issues.jboss.org/browse/TEIID-3388
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1
Reporter: Juraj DurĂ¡ni
Assignee: Steven Hawkins
Attachments: server_ora10.log, server_ora12.log
Queries:
1. SELECT RADIANS(DoubleNum) FROM BQT1.SmallA ORDER BY DoubleNum;
2. SELECT RADIANS(FloatNum) FROM BQT1.SmallA ORDER BY FloatNum;
Both queries return different null ordering. In case of DoubleNum nulls are first. In the
second case nulls are last records.