[jira] [Resolved] (ASTERIXDB-2428) Incorrect result with limit if offset is negative

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

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dmitry Lychagin resolved ASTERIXDB-2428.
----------------------------------------
    Resolution: Fixed

> Incorrect result with limit if offset is negative 
> --------------------------------------------------
>
>                 Key: ASTERIXDB-2428
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2428
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: Dmitry Lychagin
>            Assignee: Dmitry Lychagin
>            Priority: Minor
>
> The following query should return two items, but it currently returns an empty result:
> select value paper
> from DBLP1 as paper
> order by dblpid
> limit 2 offset -get_year(current_date());
> When an offset is negative its considered to be 0.
> The problem is caused by CopyLimitDownRule which simply adds offset to the limit when copying the limit clause. So in this particular case the newly created limit clause will have a negative limit which equivalent to 0, hence no results.
>  



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