[teiid-issues] [JBoss JIRA] (TEIID-4449) Allow limited replanning of subplans that use only common tables
[
https://issues.jboss.org/browse/TEIID-4449?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4449.
-----------------------------------
Resolution: Done
Updated the planner to consolidate how the with clause is assigned to source queries and
to check for repeated usage of the same common table, which triggers a replanning with the
common table effectively marked as materialized.
Allow limited replanning of subplans that use only common tables
-----------------------------------------------------------------
Key: TEIID-4449
URL: https://issues.jboss.org/browse/TEIID-4449
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.1
If a common table is fully pushed and not marked as materialized, then it could be used
in subplans in a trivial way:
with x as ... select col from x
It would be better to have that access reference a materialized common table, rather than
pushed separately.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)