[teiid-issues] [JBoss JIRA] (TEIID-2040) Failed Assertion during org.teiid.query.processor.relational.SortUtility.<init>

[ https://issues.jboss.org/browse/TEIID-2040?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2040: ---------------------------------- Description: The issue here is with push aggregates running after choose dependent and altering the schema of the independent side of a join that is later referenced by the dependent sort logic. Steps to Reproduce: SimpleRecursion.vdb attached in SFDC ticket. Can replicate by deploying VDB to server, and running the query against the VDB. was: SimpleRecursion.vdb attached in SFDC ticket. Can replicate by deploying VDB to server, and running the query [1] against the VDB. Related -ds.xml will be attached here. [1] SELECT E0.ID AS C0, R.ID AS C1 FROM SourceCM.DEPENDANTS AS R LEFT JOIN (SourceCM.PARENT_CHILD AS E0 JOIN SourceCM.TOP AS E1 ON E0.PARENT_ID=E1.ID) ON R.PARENT_ID=E0.ID WHERE E1.NAME='Tree 1' GROUP BY E0.ID,R.ID ORDER BY C1 LIMIT 0,5000 The PARENT_CHILD table is derived by a simple virtual procedure, if he switches this to a table there are no issues, so it's seem to be something with the input parameter and the procedure. Testing with his query if you just remove the WHERE clause it succeeds. If you add the E1.NAME to the SELECT list, you'll see that there are values for this column. -- 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