[
https://issues.apache.org/jira/browse/IGNITE-2602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Ozerov closed IGNITE-2602.
-----------------------------------
> Queries: offset does not work with negative or MAX_VALUE limit
> --------------------------------------------------------------
>
> Key: IGNITE-2602
> URL: https://issues.apache.org/jira/browse/IGNITE-2602
> Project: Ignite
> Issue Type: Bug
> Components: cache, sql
> Affects Versions: 1.1.4
> Reporter: Pavel Tupitsyn
> Priority: Major
>
> H2 allows specifying negative LIMIT with OFFSET:
> http://www.h2database.com/html/grammar.html
> This does not work with Ignite (query returns empty result set).
> To work around this, I tried to specify Integer.MAX_VALUE, but this causes an
> exception.
> Turns out, offset+limit should be <= Integer.MAX_VALUE, which is quite
> inconvenient.
> I think we should support negative LIMIT for unlimited offset queries.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
