Common table expressions are not pre-evaluated ---------------------------------------------- Key: TEIID-3139 URL: https://issues.jboss.org/browse/TEIID-3139 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.7.1, 8.9 With sql such as: {code} with test as ( select CURDATE() as startDate from schema.table) select startDate from test {code} The curdate function will be pushed to the source regardless of whether it is supported. It should be pre-evaluated prior to pushdown.