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

[Bram Gadeyne (JIRA)]

Bram Gadeyne created TEIID-5409:
-----------------------------------

             Summary: left join is ignored
                 Key: TEIID-5409
                 URL: https://issues.jboss.org/browse/TEIID-5409
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 10.3.2
            Reporter: Bram Gadeyne
            Assignee: Steven Hawkins
         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 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_.



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