[teiid-issues] [JBoss JIRA] (TEIID-4232) Wrong detection of recursive plans when same aliases are used in nested CTEs
Salvatore R (JIRA)
issues at jboss.org
Fri May 27 11:24:00 EDT 2016
Salvatore R created TEIID-4232:
----------------------------------
Summary: Wrong detection of recursive plans when same aliases are used in nested CTEs
Key: TEIID-4232
URL: https://issues.jboss.org/browse/TEIID-4232
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Salvatore R
Assignee: Steven Hawkins
I defined the following view:
{code:sql}
create view v1 as
WITH mycte as (SELECT 1 as col1) SELECT col1 FROM mycte;
{code}
If I run this query:
{code:sql}
WITH mycte as (SELECT * FROM views.v1) SELECT * from mycte ;
{code}
it fails on generate the query plan with this exception:
{code}
TEIID31124 Recursive plan detected. Command type Query was already issued against mycte. Planning cycle: [Query mycte, Query views.v1]
{code}
Using /*+ no_inline */ hint to prevent the inlining doesn't fail and returns the correct result.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list