[teiid-issues] [JBoss JIRA] (TEIID-5532) Common table projection minimization does not account for usage in a subquery nested in an aggregate or in some view scenarios

[dalex dalex (Jira)]

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

dalex dalex commented on TEIID-5532:
------------------------------------

[~shawkins] thx a lot! I've just checked the next commit and it worked. My query started to work faster in twice than before the your latest commit and seems the query works with the same speed than before the entire issue.

> Common table projection minimization does not account for usage in a subquery nested in an aggregate or in some view scenarios
> ------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-5532
>                 URL: https://issues.jboss.org/browse/TEIID-5532
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 11.0.3, 11.1.2, 12.0, 11.2.1
>
>
> Nesting the usage of a common table in an aggregate means that the columns can be removed inappropriately by projection minimization.  A query such as:
> with CTE1 as /*+ no_inline */ (SELECT e1, e2, e3 from pm1.g1) 
> select array_agg((select e3 from cte1 where e1=pm1.g2.e1 and e2=pm1.g2.e2)) from pm1.g2
> will return null values for all e3 as projection minimization of CTE1 will replace the column with a null value.
> A similar situation occurs when the query above is defined instead in a view.  A similar issue was captured on TEIID-5535



--
This message was sent by Atlassian Jira
(v7.12.1#712002)