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, Patch Release, Teiid Integration Reporter: Steven Hawkins Assignee: Paul Richardson Fix For: 10.0.1, 9.2.1 Attachments: RCTE1-vdb.xml 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