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

NPE when CTE and subuquery without a WITH clause are pushed together

    Details

      Description

      With a query such as:

      WITH qry_0 as /*+ no_inline */ (SELECT e2 AS a1, e1 as str FROM pm1.g1 AS t) select (select e1 from pm1.g1) as x, a1 from qry_0

      that is pushed together to the source, the relationalplanner will throw an NPE when pulling up any nested with clauses because there is no with clause assigned to the subquery.

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: