[jira] [Updated] (CASSANDRA-9913) Select * is only returning the first page of data on trunk

["Benjamin Lerer (JIRA)" <ji...@apache.org>]

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

Benjamin Lerer updated CASSANDRA-9913:
--------------------------------------
    Attachment: 9913.txt

The patch fix 2 problems:
# For the {{SELECT * FROM Standard1}} query, the problem was that the query was considered wrongly as a range query. It was due to the fake clustering column {{column1}} that is part of the static compact tables schema. The patch make sure that the column is ignored for static compact tables.
# For the {{SELECT count(*) FROM Standard1}} query, the problem was caused by the fact that the {{RowIterator}} was not closed.  

> Select * is only returning the first page of data on trunk
> ----------------------------------------------------------
>
>                 Key: CASSANDRA-9913
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9913
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Philip Thompson
>            Assignee: Benjamin Lerer
>             Fix For: 3.0 beta 1
>
>         Attachments: 9913.txt
>
>
> While doing some testing on the validation harness, I have run into a pretty trivially reproducible problem.
> {code}
> ccm create test -v git:trunk -n 1 -s
> ccm node1 stress write n=2M
> ccm node1 cqlsh
> {code}
> {code}
> Use keyspace1;
> Select * From standard1; (100 rows)
> Select count(*) from standard1; (300 rows)
> {code}
> Despite two million rows being written, I have found that {{select * from standard1}} only returns one page's worth of data. I have used both the java and the python driver to test this. I have also found that {{select count(*) from standard1}} gives a multiple of one page's worth of data, that appears to correspond to page size * RF.
> I have already tried with the patch for CASSANDRA-9775, and that did not resolve this issue.



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