[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-216) Designer removes parentheses around criteria in ansi join when using compound ON
[
https://jira.jboss.org/jira/browse/TEIIDDES-216?page=com.atlassian.jira.p...
]
Larry O'Leary commented on TEIIDDES-216:
----------------------------------------
This may have something to do with how JoinPredicate is constructed. When adding some
test cases to a UnitTest I noticed that JoinPredicate may get constructed in two different
ways depending on who is constructing it. One way is to pass the criteria as as Criteria
which may (or may not) contain compound criteria. The other is to pass the criteria as a
List of Criteria in which case it appears the List normally contains one element of type
Criteria which may (or may not) be CompundCriteria. In the first instance, the
CompoundCriteria is broken apart into a List separated by the ANDs of the CompundCriteria.
Of course at a glance it does not appear it takes into consideration that order of
operations may be broken. If this is the case, this issue may need to be moved to Teiid.
Designer removes parentheses around criteria in ansi join when using
compound ON
--------------------------------------------------------------------------------
Key: TEIIDDES-216
URL: https://jira.jboss.org/jira/browse/TEIIDDES-216
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 6.1.0
Reporter: Marc Shirley
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 contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira