You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2018/07/26 18:29:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16558721#comment-16558721 ]
ASF subversion and git services commented on ASTERIXDB-2424:
------------------------------------------------------------
Commit f804ad279f94ff8f4bbc4be637d0049793b5da10 in asterixdb's branch refs/heads/master from [~dlychagin-cb]
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=f804ad2 ]
[ASTERIXDB-2424][COMP] No limit pushdown if multiple limit clauses
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
- CopyLimitDownRule should not stop at the first limit clause it processes
Change-Id: Id92bb99c57d1363740b0ccbb09bceb59da968ca0
Reviewed-on: https://asterix-gerrit.ics.uci.edu/2815
Sonar-Qube: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Contrib: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Taewoo Kim <wa...@gmail.com>
> 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)