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

["Till Westmann (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Till Westmann updated ASTERIXDB-2679:
-------------------------------------
    Attachment: no-function.txt

> 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
>            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)