]
Barry LaFond commented on TEIIDDES-2481:
----------------------------------------
[~phantomjinx] Should only require upgrading to 8.10+ Teiid source?
Add support for recursive common table expressions
--------------------------------------------------
Key: TEIIDDES-2481
URL:
https://issues.jboss.org/browse/TEIIDDES-2481
Project: Teiid Designer
Issue Type: Feature Request
Components: Modeling
Reporter: Steven Hawkins
Assignee: Paul Richardson
Fix For: 9.2
Teiid 8.10 added support for recursive common table expressions. There is no new syntax,
but more logic around resolving a special form of a common table expression. If the query
expression is written as a union then the right hand side of the union is allowed to
reference the common table group. See
https://docs.jboss.org/author/display/TEIID/WITH+Clause