[CASSANDRA-11208] Paging is broken for IN queries

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Component/s: Legacy/CQL
• Severity: Normal
• Since Version: 3.0.0
• Assignee: Benjamin Lerer
• Reporter: Benjamin Lerer

Authors

Benjamin Lerer

Reviewers

Sylvain Lebresne

• Created: 22/Feb/16 20:47
• Updated: 16/Apr/19 09:30
• Resolved: 10/Mar/16 11:07

Description

If the number of selected row is greater than the page size, C* will return some duplicates.

The problem can be reproduced with the java driver using the following 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 test (rc int, pk int, PRIMARY KEY (pk))");

       for (int i = 0; i < 5; i++)
           session.execute("INSERT INTO test (pk, rc) VALUES (?, ?);", i, i);

       ResultSet rs = session.execute(session.newSimpleStatement("SELECT * FROM test WHERE  pk IN (1, 2, 3)").setFetchSize(2));

Issue Links

• relates to: CASSANDRA-13302 last row of previous page == first row of next page while querying data using SASI index