[teiid-issues] [JBoss JIRA] (TEIID-4096) AssertionError with independent side of a dependent join that has an ordered limit

AssertionError with independent side of a dependent join that has an ordered limit ---------------------------------------------------------------------------------- Key: TEIID-4096 URL: https://issues.jboss.org/browse/TEIID-4096 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.11 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.0, 8.12.5, 8.13.3 An independent side with a nested ordered limit: with a (x, y, z) as (select e1, e2, e3 from pm1.g1) SELECT a.x, b.e1 from a, /*+ makeind */ (SELECT * from pm1.g2, a where e1 = x and z = 1 order by e2 limit 2) as b where a.x = b.e1 will cause an assertion error in sorting the dependent values: 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:151) at org.teiid.query.processor.relational.SortUtility.<init>(SortUtility.java:187) at org.teiid.query.processor.relational.DependentCriteriaProcessor$TupleState.sort(DependentCriteriaProcessor.java:113) Because the schema being used is from the below the limit/order by and effectively the source node.