]
Steven Hawkins resolved TEIID-5530.
-----------------------------------
Resolution: Partially Completed
Added a doc note about the inlining with correlated subqueries.
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.