[teiid-issues] [JBoss JIRA] (TEIID-4232) Wrong detection of recursive plans when same aliases are used in nested CTEs
Steven Hawkins (JIRA)
issues at jboss.org
Tue May 31 14:01:03 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-4232:
----------------------------------
Affects Version/s: 9.0
> 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
> Affects Versions: 9.0
> Reporter: Salvatore R
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> 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