[teiid-issues] [JBoss JIRA] (TEIID-3866) with clause used by subquery repeated in the subquery

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3866:
-------------------------------------

             Summary: with clause used by subquery repeated in the subquery
                 Key: TEIID-3866
                 URL: https://issues.jboss.org/browse/TEIID-3866
             Project: Teiid
          Issue Type: Quality Risk
          Components: Query Engine
    Affects Versions: 8.7
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 8.13, 8.12.4


A query such as:

with eee as (select * from pm1.g1) select * from pm1.g2 where pm1.g2.e1 in (select e1 from eee)

will result in a push down that repeats the with clause in the subquery:

... (with eee ... select e1 from eee)

It is sufficient to rely on the parent to define the common table.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)