[teiid-issues] [JBoss JIRA] (TEIID-4737) Incorrect work of left join statement

[dalex dalex (JIRA)]

dalex dalex created TEIID-4737:
----------------------------------

             Summary: Incorrect work of left join statement
                 Key: TEIID-4737
                 URL: https://issues.jboss.org/browse/TEIID-4737
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 9.0.3
         Environment: teiid-9.0.3 on WildFly Full 9.0.2.Final (WildFly Core 1.0.2.Final)
            Reporter: dalex dalex
            Assignee: Steven Hawkins
            Priority: Blocker
         Attachments: test_emails_bug1.jpg, test_emails_pg.jpg

the following query:
{code:sql}
SELECT a.email, b.email, lower(a.email), lower(b.email) FROM test_tables.test_emails as a left join views.test_view_emails as b on lower(a.email)=lower(b.email)
{code}
leads to the following results:
 !test_emails_bug1.jpg|thumbnail! 

though running the same query on PostgreSQL leads to the following results:
 !test_emails_pg.jpg|thumbnail! 
so this query mentioned above must work as on PostgreSQL putting null values for the b field table where conditions can't be performed.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)