Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5934

Inappropriate aggregate pushdown over nested table join

    Details

    • Sprint:
      DV Sprint 62
    • Story Points:
      0.5

      Description

      Related to TEIID-5932, a query with multiple lateral joins and a group by is optimized incorrectly. Altering the unit test query to:

      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
      

      Results in a processing error because the initial pushdown for tbl only selects count star and does not select tbl.str.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4 hours
                  4h
                  Remaining:
                  Time Spent - 3 hours Remaining Estimate - 1 hour
                  1h
                  Logged:
                  Time Spent - 3 hours Remaining Estimate - 1 hour
                  3h