[
https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2481:
----------------------------------------
[~shawkins] I looked at that test class and followed the methods into TeiidProcessor but I
don't see where any query resolving is happening (i.e. valid groups/symbols).
The error we're getting is around the "internal" group name (Emp_CTE above).
Matus verified that a Dynamic VDB deploys OK with this type of SQL, so I'm assuming
the example we're using is valid?
I'm having the same issue with one of your tests :
TestWithClauseProcessing.testRecursive()
{code}
WITH t(n) AS ( VALUES (1) UNION ALL SELECT n+1 FROM t WHERE n < 64 ) SELECT sum(n) FROM
t
{code}
ERROR : *Group does not exist: t*
Since *t* is not an external table/view, shouldn't that internal "metadata"
be taken into account during process?
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)