[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 resolved TEIID-2717.
-----------------------------------

    Resolution: Done


Corrected the planning error by always ensuring that an expression symbol is used in the order by item when needed. 

Also updated rule plan sorts to look for the simplistic case where the dup removal of the union can be combined with the sort above.
                
> 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