[
https://issues.jboss.org/browse/TEIID-5530?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5530:
---------------------------------------
There isn't a great way to address this with the current code structure. The inlining
happens during rewrite before correlated references are generally set. I'll resolve
this for now with a doc note.
common tables used in only 1 location which is a subquery still
inlined
-----------------------------------------------------------------------
Key: TEIID-5530
URL:
https://issues.jboss.org/browse/TEIID-5530
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Major
Fix For: 12.0
With a query such as:
with x as (select ...)
select (select ... from x where ...) from y
The x common table is inlined even though it may be less efficient for processing.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)