]
Paul Nittel closed TEIIDDES-644.
--------------------------------
Resolution: Cannot Reproduce Bug
This was "fixed" as the Books project has been removed from the examples. (Look
for its return before GA.)
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: