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, 8.12.17.6_4 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