[jira] [Created] (ASTERIXDB-2424) Limit is not pushed down the the data source scan if multiple limit clauses

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

Dmitry Lychagin created ASTERIXDB-2424:
------------------------------------------

             Summary: Limit is not pushed down the the data source scan if multiple limit clauses
                 Key: ASTERIXDB-2424
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2424
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: COMP - Compiler
            Reporter: Dmitry Lychagin
            Assignee: Dmitry Lychagin


In the following query the limit inside subquery (limit 1) can pushed down to the data scan but currently it is not.

select dblpid from DBLP1 d
where d.dblpid = (
 select * from DBLP1 d where ends_with(dblpid, "ley95") limit 1
)[0].d.dblpid
limit 2

 



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