[teiid-designer-issues] [JBoss JIRA] Updated: (TEIIDDES-216) Designer removes parentheses around criteria in ansi join when using compound ON

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 Components: Transformations Affects Versions: 6.1.0 Reporter: Marc Shirley Fix For: Future 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)