Inappropriate aggregate pushdown over nested table join ------------------------------------------------------- Key: TEIID-5934 URL: https://issues.redhat.com/browse/TEIID-5934 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Major Fix For: 14.0, 13.1.1 Original Estimate: 4 hours Time Spent: 3 hours Remaining Estimate: 1 hour Related to TEIID-5932, a query with multiple lateral joins and a group by is optimized incorrectly. Altering the unit test query to: {code} SELECT xt.event_id, count(*) FROM tbl AS d, TABLE (select d.event_id from tbl limit 1) xt LEFT JOIN TABLE (select tbl.str as some_col from tbl where str = 'a' || d.str) xt2 ON xt.event_id = -1 group by xt.event_id {code} Results in a processing error because the initial pushdown for tbl only selects count star and does not select tbl.str.