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

Teiid selects incorrect source when conformed table is included in SQL JOIN

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.8, 8.7.1
    • 8.7
    • Query Engine
    • None

    Description

      I have two models. postgres for PostgreSQL and mysql for MySQL. I have table test.conformedTable in the both models
      and I have configured conformedTable to be conformed. Table tablepostgre is in the PostgreSQL database. Table tablemysql in the MySQL.

      I want to join conformedTable with tablepostgre and tablemysql.

      The query
      select a.,b. from mysql.test.conformedTable as a, tablemysql b where a.id=b.id
      is processed OK, but query
      select a.,b. from mysql.test.conformedTable as a, tablepostgre b where a.id=b.id throws an exception (in the attachment)

      It seems that teiid searches tablepostgre in the mysql database, but the table is in the postgresql

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            felias_jira Filip Elias (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: