[teiid-issues] [JBoss JIRA] (TEIID-4129) Wrong results with cross model join on 2 varchar fields

Wrong results with cross model join on 2 varchar fields ------------------------------------------------------- Key: TEIID-4129 URL: https://issues.jboss.org/browse/TEIID-4129 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Mark Tawk Assignee: Steven Hawkins Fix For: 9.1, 8.12.13.6_4 Attachments: H2 DBs.zip, MetaDataStores.zip I'm using Teiid 8.11.3 with H2 translator. I'm joining 2 h2 tables from 2 different teiid models linked on varchar fields. the query result is retuning empty values from the joined table even though the joined values are identical. You find attached a zip file containing 2 h2 DBs for a simplified example Here is the query used: _select "Customer"."City" as "Customer_City","Customer"."CustomerID" as "Customer_CustomerID","City"."City" as "City_City","City"."CityID" as "City_CityID" from "db2"."Customer" "Customer" LEFT JOIN "db1"."City" "City" ON "Customer"."City" = "City"."City"_ Note that if the 2 tables are in the same model, the query return correct results.