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

Wrong results with cross model join on 2 varchar fields

    XMLWordPrintable

    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.

        Attachments

        1. H2 DBs.zip
          21 kB
        2. MetaDataStores.zip
          8 kB

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: