[
https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-2481:
------------------------------------------
Since t is not an external table/view, shouldn't that internal
"metadata" be taken into account during process?
I'm not sure what you as asking.
A recursive common table look like
with x as (
foo
union [all]
bar
)
such that bar can reference the common table x.
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
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)