[teiid-issues] [JBoss JIRA] (TEIID-3388) Different null ordering for float and double numbers with RADIANS function (Oracle 12)

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-3388.
---------------------------------


> 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)