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

[Steven Hawkins (JIRA)]

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

Steven Hawkins closed TEIID-4096.
---------------------------------


> 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
(v7.5.0#75005)