[teiid-issues] [JBoss JIRA] (TEIID-2717) Issues with unrelated sort over a union

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-2717.
---------------------------------


    
> Issues with unrelated sort over a union
> ---------------------------------------
>
>                 Key: TEIID-2717
>                 URL: https://issues.jboss.org/browse/TEIID-2717
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.7
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.6
>
>
> Related to https://community.jboss.org/thread/233978 a query such as:
> select e1 || 'a' from (select e1, e2 from pm1.g1 union select e1, e2 from pm1.g2) as x order by e2 || 'b'
> will fail to plan and throw TEIID30259.  The issue is that the unrelated sort item should still be an expression symbol, otherwise the assign output logic assumes that it is a must pushdown function.
> Also the simpler form without an unrelated expression:
> select e1 || 'a' from (select e1, e2 from pm1.g1 union select e1, e2 from pm1.g2) as x order by e2
> can have the dup remove and the sort operations combined.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira