[
https://issues.apache.org/jira/browse/ASTERIXDB-2424?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin resolved ASTERIXDB-2424.
----------------------------------------
Resolution: Fixed
> 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
> Priority: Minor
>
> 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)
