Juraj Duráni created TEIID-3388:
-----------------------------------
Summary: 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.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)