-
Type:
Bug
-
Status: Resolved (View Workflow)
-
Priority:
Blocker
-
Resolution: Done
-
Affects Version/s: 9.0.3
-
Fix Version/s: 9.0.6, 9.2, 9.1.4, 8.7.12.6_2, 8.12.10.6_3
-
Component/s: Query Engine
-
Labels:None
-
Environment:
teiid-9.0.3 on WildFly Full 9.0.2.Final (WildFly Core 1.0.2.Final)
-
Steps to Reproduce:
-
Bugzilla Update:Perform
the following query:
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) |
leads to the following results:
though running the same query on PostgreSQL leads to the following results:
so this query mentioned above must work as on PostgreSQL putting null values for the b field table where conditions can't be performed.