Jasper van Ams created PHOENIX-3353:
---------------------------------------
Summary: Paged Queries: use of LIMIT + OFFSET with ORDER BY
Key: PHOENIX-3353
URL: https://issues.apache.org/jira/browse/PHOENIX-3353
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.8.0, 4.8.1
Environment: Phoenix 4.8.1 Hbase 1.2
Reporter: Jasper van Ams
As per documentation (https://phoenix.apache.org/paged.html)
SELECT * FROM FOO LIMIT 10 OFFSET 10
returns rows 11 to 20.
However when adding ORDER BY it returns nothing. Only raising the LIMIT with
the appropriate OFFSET i.e.
SELECT * FROM FOO ORDER BY BAR LIMIT 20 OFFSET 10
will now return rows 11 to 20.
(Alternatively; SELECT * FROM FOO LIMIT 20 OFFSET 10 returns rows 11 to 30)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
