cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin Lerer (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-11669) RangeName queries might not return all the results
Date Thu, 28 Apr 2016 08:08:12 GMT

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

Benjamin Lerer updated CASSANDRA-11669:
---------------------------------------
    Fix Version/s: 3.x
                   3.0.x

> RangeName queries might not return all the results
> --------------------------------------------------
>
>                 Key: CASSANDRA-11669
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11669
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>             Fix For: 3.0.x, 3.x
>
>
> It seems that if a page end in the middle of a partition the remaining rows of the partition
will never be returned.
> The problem can be reproduced using the java driver with the following code:
> {code}
>         session = cluster.connect();
>         session.execute("CREATE KEYSPACE IF NOT EXISTS test WITH REPLICATION = {'class'
: 'SimpleStrategy', 'replication_factor' : '1'}");
>         session.execute("USE test");
>         session.execute("DROP TABLE IF EXISTS test");
>         session.execute("CREATE TABLE IF NOT EXISTS test (a int, b int, c int, d int,
PRIMARY KEY(a, b, c))");
>         PreparedStatement prepare = session.prepare("INSERT INTO test (a, b, c, d) VALUES
(?, ?, ?, ?);");
>         for (int i = 1; i < 4; i++)
>             for (int j = 1; j < 5; j++)
>                 for (int k = 1; k < 5; k++)
>                 session.execute(prepare.bind(i, j, k, i + j));
>         ResultSet rs = session.execute(session.newSimpleStatement("SELECT * FROM test
WHERE b = 1 and c IN (1, 2, 3) ALLOW FILTERING")
>                                               .setFetchSize(4));
>         for (Row row : rs)
>         {
>             System.out.println(row); // Only one row will be returned for partition 2
instead of 3
>         }
> {code}



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

Mime
View raw message