You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Philip Thompson (JIRA)" <ji...@apache.org> on 2015/07/28 20:59:04 UTC

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

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

Philip Thompson updated CASSANDRA-9913:
---------------------------------------
    Description: 
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.

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


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