[
https://issues.jboss.org/browse/TEIIDDES-216?page=com.atlassian.jira.plug...
]
Mark Drilling resolved TEIIDDES-216.
------------------------------------
Fix Version/s: 8.0
(was: 8.1)
Resolution: Done
I retested this in 8.0 alpha1 and it is working as expected, so assuming this was resolved
as indicated previously.
Designer removes parentheses around criteria in ansi join when using
compound ON
--------------------------------------------------------------------------------
Key: TEIIDDES-216
URL:
https://issues.jboss.org/browse/TEIIDDES-216
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 6.1.0
Reporter: Marc Shirley
Assignee: Mark Drilling
Fix For: 8.0
In Designer, when validating a transformation that has compound criteria in an ansi join
statement's ON, the parentheses are removed and the order of operations is modified as
a result. This does not appear to occur when using the same parentheses structure in
WHERE criteria.
Before validation:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON (a.INTKEY = b.INTKEY) AND
(a.INTNUM IS NULL OR a.INTNUM = 11)
After validation:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON a.INTKEY = b.INTKEY AND
(a.INTNUM IS NULL) OR (a.INTNUM = 11)
After validating a second time:
SELECT * FROM bqt.SMALLA AS a INNER JOIN bqt.SMALLB AS b ON ((a.INTKEY = b.INTKEY) AND
(a.INTNUM IS NULL)) OR (a.INTNUM = 11)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira