[ASTERIXDB-2679] Predicate pushdown through join not working in functions

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.5
• Fix Version/s: 0.9.8
• Component/s: *DB - AsterixDB, SQL - Translator SQL++
• Assignee: Dmitry Lychagin
• Reporter: Gift Sinthong
• Created: 18/Nov/19 21:22
• Updated: 17/Feb/22 02:39

Description

Using TinySocial, why doesn't the following function and query

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%';

have the same query plan as

select u.name, m.message from
GleambookUsers u, GleambookMessages m
where u.id = m.authorId 
and u.name like 'M%';

in which the name predicate is pushed below the join?