[teiid-issues] [JBoss JIRA] (TEIID-1949) AssertionError with Teiid order by over pushed group by

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-1949.
-----------------------------------

    Fix Version/s: 7.7
       Resolution: Done


The grouping rewrite in rulecollapsesource was causing the node output elements to change since the clauses were not cloned.
                
> AssertionError with Teiid order by over pushed group by
> -------------------------------------------------------
>
>                 Key: TEIID-1949
>                 URL: https://issues.jboss.org/browse/TEIID-1949
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.6
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.7
>
>
> With a user query similar to:
> SELECT DB.Address, DB.City, count(*) as Count FROM "Emp"."persons" as DB
> GROUP BY DB.Address, DB.City
> ORDER BY DB.City
> If the grouping is pushed, but the order by is not an AssertionError will occur:
> java.lang.AssertionError: Assertion failed.
>             at org.teiid.core.util.Assertion.failed(Assertion.java:73)
>             at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68)
>             at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60)
>             at org.teiid.query.processor.relational.SortUtility.<init>(SortUtility.java:145)
> It does not occur if neither or both are pushed.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira