[
https://issues.apache.org/jira/browse/PHOENIX-3353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15555269#comment-15555269
]
Jasper van Ams commented on PHOENIX-3353:
-----------------------------------------
Important addition, given that: BAR is not a primary key of the FOO table
> 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
> Labels: limit, offset, orderby, paging
>
> 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)
