Steven Hawkins created TEIID-5529: ------------------------------------- Summary: Non-pushed subquery may have evaluatable predicates not pushed Key: TEIID-5529 URL: https://issues.jboss.org/browse/TEIID-5529 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 12.0 For example, a source that does not support lower nor correlated subqueries and a query like: SELECT array_agg((select intkey from bqt1.smallb where stringkey = lower(a.stringkey))) from bqt1.smalla a will not push stringkey = lower(a.stringkey) to the n-many subquery, even though it can be pre-evaluated with the correlated value. -- This message was sent by Atlassian Jira (v7.12.1#712002)