[
https://issues.apache.org/jira/browse/CASSANDRA-8408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philip Thompson updated CASSANDRA-8408:
---------------------------------------
Reproduced In: 2.1.2, 2.0.12 (was: 2.0.12, 2.1.2)
Fix Version/s: 2.1.3
2.0.12
> limit appears to replace page size under certain conditions
> -----------------------------------------------------------
>
> Key: CASSANDRA-8408
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8408
> Project: Cassandra
> Issue Type: Bug
> Reporter: Russ Hatch
> Assignee: Tyler Hobbs
> Priority: Minor
> Fix For: 2.0.12, 2.1.3
>
>
> This seems it could be related to CASSANDRA-8403.
> When paging a query with:
> limit < page size << data size, and querying using an 'IN' clause across
> several partitions, I get back several pages of size=limit (instead of the
> page size being used). So the limit is being exceeded and it seems to
> supplant the page size value, but something is still keeping the total rows
> returned down.
> To repro, create a table:
> CREATE TABLE paging_test ( id int, value text, PRIMARY KEY (id, value) )
> And add data across several partitions (I used 6 partitions). Add a bunch of
> rows to each partition (I have 80 total across all partitions).
> Perform a paged query using an 'IN' clause across all the partitions, where:
> limit < page_size << data size. I used something like:
> SELECT * FROM paging_test where id in (1,2,3,4,5,6) LIMIT 9;
> (with a page_size of 20 for the query).
> What I get returned is three pages of sizes: 9, 9, 8 -- 26 rows in total but
> I'm uncertain why.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
