[teiid-issues] [JBoss JIRA] (TEIID-5468) Potentially unexpected results due to null ordering with window functions

Steven Hawkins (JIRA) issues at jboss.org
Thu Sep 13 11:35:00 EDT 2018


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

Steven Hawkins resolved TEIID-5468.
-----------------------------------
    Fix Version/s: 11.2
                   11.1.1
                   11.0.3
       Resolution: Done


Extended the null order handling to order bys that exist in ordered limit views, aggregates, and window functions.

> Potentially unexpected results due to null ordering with window functions
> -------------------------------------------------------------------------
>
>                 Key: TEIID-5468
>                 URL: https://issues.jboss.org/browse/TEIID-5468
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Documentation, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 11.2, 11.1.1, 11.0.3
>
>
> Similar to documentation notes that we make about the final user ordering, we should document that without an explicit ordering or the flag to push the teiid default ordering that window functions results may be different on a source with a different default null order.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)


More information about the teiid-issues mailing list