Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4129

Wrong results with cross model join on 2 varchar fields

    Details

    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Set the translator property CollationLocale to any value that does not match the system property org.teiid.collationLocale (which is not required to be set).

      Show
      Set the translator property CollationLocale to any value that does not match the system property org.teiid.collationLocale (which is not required to be set).

      Description

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  mtawk Mark Tawk
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: