[teiid-issues] [JBoss JIRA] (TEIID-5934) Inappropriate aggregate pushdown over nested table join
Steven Hawkins (Jira)
issues at jboss.org
Mon Apr 13 22:37:23 EDT 2020
Steven Hawkins created TEIID-5934:
-------------------------------------
Summary: 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
Fix For: 14.0
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.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
More information about the teiid-issues
mailing list