]
Steven Hawkins resolved TEIID-4257.
-----------------------------------
Resolution: Done
Limiting the nesting to only the right hand side for H2.
Nesting join parens cause H2 performance issue
----------------------------------------------
Key: TEIID-4257
URL:
https://issues.jboss.org/browse/TEIID-4257
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Connector
Affects Versions: 8.12
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.1
The fix for TEIID-3549 introduced nesting parens on both the left and right side - but
having the left nesting causes different optimization behavior for H2.