[teiid-issues] [JBoss JIRA] (TEIID-5409) left join is reversed

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-5409.
-----------------------------------
    Resolution: Done


The issue was with a utility method created from a minor refactoring.  It added join node children in a non-obvious manner.  This fix was applied to all source branches back to 9.3 in case anyone wants to build from source to address on an older branch.

> left join is reversed
> ---------------------
>
>                 Key: TEIID-5409
>                 URL: https://issues.jboss.org/browse/TEIID-5409
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 10.3.1, 10.3.2
>            Reporter: Bram Gadeyne
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 11.1, 11.0.1, 10.3.3
>
>         Attachments: plan_teiid_10.3.2.txt, plan_teiid_9.1.txt
>
>
> A query that is run on teiid 9.1 results in 56186 rows.
> The same query that is run on teiid 10.3.2 results in 5919 rows.
> It seems like the left join is reversed.
> I've attached both query plans.
> The queries are exactly the same. Note that on 9.1 we've prefixed table names with cos2_5_.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)