Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-644

Books example has incorrect transformation SQL in XML document model

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • 7.1.1
    • 7.1.1
    • None
    • None

    Description

      I imported the Books Project into my workspace and found the XML document model had errors, Checking, I found the transformation SQL referenced the wrong models. For example,
      SELECT
      Books_Oracle.AUTHORS.LASTNAME AS author
      FROM
      Books_SQLServer.BOOK_AUTHORS, Books_Oracle.AUTHORS
      WHERE
      ("input".isbn = Books_SQLServer.BOOK_AUTHORS.ISBN) AND (Books_SQLServer.BOOK_AUTHORS.AUTHOR_ID = Books_Oracle.AUTHORS.AUTHOR_ID)

      should reference Books_SourceA and Books_SourceB rather than Books_SQLServer and Books_Oracle.

      Attachments

        Activity

          People

            Unassigned Unassigned
            pnittel_jira Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: