[teiid-issues] [JBoss JIRA] (TEIID-5529) Non-pushed subquery may have evaluatable predicates not pushed

[Steven Hawkins (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5529.
-----------------------------------
    Resolution: Done


Updated the criteria validation logic to selectively use different checks of whether an expression will evaluate to a constant depending upon whether it's in the context of just a query or the inclusion of a subquery for pushdown.

> 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
>            Priority: Major
>             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)