[teiid-issues] [JBoss JIRA] (TEIID-5530) common tables used in only 1 location which is a subquery still inlined

[Steven Hawkins (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13666959#comment-13666959 ] 

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)