[jira] [Created] (ASTERIXDB-2679) Predicate pushdown through join not working in functions

["Gift Sinthong (Jira)" <ji...@apache.org>]

Gift Sinthong created ASTERIXDB-2679:
----------------------------------------

             Summary: 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
             Fix For: 0.9.5


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)