Pavel Tupitsyn created IGNITE-2602:
--------------------------------------
Summary: 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
Affects Versions: 1.1.4
Reporter: Pavel Tupitsyn
Fix For: 1.6
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
(v6.3.4#6332)
