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

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4096:
-------------------------------------

             Summary: 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.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)