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

Wrong results with cross model join on 2 varchar fields

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.1, 8.12.13.6_4
    • 6.0.0
    • Query Engine
    • None
    • Workaround Exists
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: