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)
