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.7.8.6_2, 8.12.4, 8.13 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.