[CASSANDRA-12420] Duplicated Key in IN clause with a small fetch size will run forever

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.16
• Component/s: Legacy/CQL
• Labels: doc-impacting

Environment

cassandra 2.1.14, driver 2.1.7.1

• Severity: Normal
• Assignee: Tom Hobbs
• Reporter: Zhao Yang

Authors

Tom Hobbs

Reviewers

Benjamin Lerer

• Created: 09/Aug/16 17:07
• Updated: 16/Apr/19 09:30
• Resolved: 27/Sep/16 16:56

Description

This can be easily reproduced and fetch size is smaller than the correct number of rows.

A table has 2 partition key, 1 clustering key, 1 column.

> Select select = QueryBuilder.select().from("ks", "cf");
> select.where().and(QueryBuilder.eq("a", 1));
> select.where().and(QueryBuilder.in("b", Arrays.asList(1, 1, 1)));
> select.setFetchSize(5);

Now we put a distinct method in client side to eliminate the duplicated key, but it's better to fix inside Cassandra.

Issue Links

• is related to: CASSANDRA-8276 Duplicate values in an IN restriction on the partition key column can break paging
• relates to: CASSANDRA-12722 dtest failure in upgrade_tests.cql_tests.TestCQLNodes2RF1_Upgrade_current_2_1_x_To_indev_2_1_x.in_order_by_without_selecting_test