Books example has incorrect transformation SQL in XML document model
--------------------------------------------------------------------
Key: TEIIDDES-644
URL:
https://jira.jboss.org/browse/TEIIDDES-644
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 7.1.1
Environment: JBDS 4.0.0 M2, Designer bulid H280
Reporter: Paul Nittel
Fix For: 7.1.1
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira