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)
