You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Dmitry Lychagin (JIRA)" <ji...@apache.org> on 2018/07/26 18:30:00 UTC

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

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