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

[Bram Gadeyne (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13609493#comment-13609493 ] 

Bram Gadeyne commented on TEIID-5409:
-------------------------------------

[~shawkins], Is there a specific case where this issue occured. I was already using 10.3 for some project and I would like to check for issues that might have occured. But I'm fairly confident that this left join issue has only happened in specific cases.

> 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)