]
Juraj Duráni updated TEIID-3388:
--------------------------------
Attachment: server_ora10.log
server_ora12.log
Server logs.
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.