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

Steven Hawkins (JIRA) issues at jboss.org
Fri Jul 6 16:58:00 EDT 2018


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

Steven Hawkins updated TEIID-5409:
----------------------------------
    Component/s: Query Engine
    Description: 
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_.

  was:
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 considered as a inner join.

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_.

        Summary: left join is reversed  (was: left join is ignored)


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


More information about the teiid-issues mailing list