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

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 Fix For: 9.0.6, 9.2, 9.1.4, 8.7.12.6_2 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.