[jira] [Created] (ASTERIXDB-2438) Consider assigns when pushing limit with condition into data scan

["Dmitry Lychagin (JIRA)" <ji...@apache.org>]

Dmitry Lychagin created ASTERIXDB-2438:
------------------------------------------

             Summary: Consider assigns when pushing limit with condition into data scan
                 Key: ASTERIXDB-2438
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2438
             Project: Apache AsterixDB
          Issue Type: Improvement
          Components: COMP - Compiler
            Reporter: Dmitry Lychagin
            Assignee: Dmitry Lychagin


Currently PushLimitIntoPrimarySearchRule stops at assign operators and therefore doesn't not push select condition into data-scan if there's an assign in between. We should fix this to allow such conditions be pushed into data scan.

Here are example queries:

Q1:

select substring(dblpid, 0, 21)
from DBLP1
where dblpid > "series"
limit 1;

Q2:

select value t.user.lang
from TweetMessages t
where t.user.friends_count between 0 and 150
limit 2

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)