[
https://issues.apache.org/jira/browse/ASTERIXDB-2679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16976978#comment-16976978
]
Michael J. Carey commented on ASTERIXDB-2679:
---------------------------------------------
Additional info: We tried using the function body as a subquery, and the
problem still existed - no pushdown - so the problem isn't functions, but
rather subqueries and pushdown.
> Predicate pushdown through join not working in functions
> --------------------------------------------------------
>
> Key: ASTERIXDB-2679
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2679
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: *DB - AsterixDB, SQL - Translator SQL++
> Affects Versions: 0.9.5
> Reporter: Gift Sinthong
> Assignee: Dmitry Lychagin
> Priority: Major
> Fix For: 0.9.5
>
> Attachments: function.txt, no-function.txt
>
>
> Using TinySocial, why doesn't the following function and query
> {code:java}
> create function userJoinMessage(){
> select u.id,u.name, m.* from
> GleambookUsers u, GleambookMessages m
> where u.id = m.authorId
> };
> select t.name, t.message
> from userJoinMessage() t
> where t.name like 'M%';
> {code}
> have the same query plan as
> {code:java}
> select u.name, m.message from
> GleambookUsers u, GleambookMessages m
> where u.id = m.authorId
> and u.name like 'M%';{code}
> in which the name predicate is pushed below the join?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
