[teiid-issues] [JBoss JIRA] (TEIID-5529) Non-pushed subquery may have evaluatable predicates not pushed
Steven Hawkins (Jira)
issues at jboss.org
Fri Nov 9 18:00:00 EST 2018
[ https://issues.jboss.org/browse/TEIID-5529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-5529:
----------------------------------
Fix Version/s: 11.2.1
11.1
> 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: 11.1, 12.0, 11.2.1
>
>
> 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)
More information about the teiid-issues
mailing list