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

Jasper van Ams updated PHOENIX-3353:
------------------------------------
    Description: 
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:
SELECT * FROM FOO ORDER BY BAR LIMIT 10 OFFSET 10 
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
while
SELECT * FROM FOO LIMIT 20 OFFSET 10 
returns rows 11 to 30

In short: LIMIT + OFFSET in combo with ORDER BY on non primary key has 
unexpected returns.


  was:
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)



> 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:
> SELECT * FROM FOO ORDER BY BAR LIMIT 10 OFFSET 10 
> 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
> while
> SELECT * FROM FOO LIMIT 20 OFFSET 10 
> returns rows 11 to 30
> In short: LIMIT + OFFSET in combo with ORDER BY on non primary key has 
> unexpected returns.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to