[teiid-issues] [JBoss JIRA] (TEIID-4129) Wrong results with cross model join on 2 varchar fields
Steven Hawkins (JIRA)
issues at jboss.org
Tue Apr 19 10:10:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13193809#comment-13193809 ]
Steven Hawkins commented on TEIID-4129:
---------------------------------------
CollationLocale currently only has meaning if it matches the system property value. And for this scenario it is not required to set the system property org.teiid.requireTeiidCollation=true
I'll see if there is a warning or other logic that would help prevent this from being an issue that requires a manual workaround.
> 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
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> 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.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list