[CASSANDRA-10762] select_distinct_with_deletions_test failing in mixed version cluster

• Type: Sub-task
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.3, 3.3
• Component/s: Legacy/CQL
• Assignee: Sylvain Lebresne
• Reporter: Philip Thompson

Authors

Sylvain Lebresne

Reviewers

Benjamin Lerer

• Created: 23/Nov/15 20:39
• Updated: 16/Apr/19 09:30
• Resolved: 05/Feb/16 20:28

Description

The dtests upgrade_tests.cql_tests.TestCQLNodes3RF3.select_distinct_with_deletions_test and upgrade_tests.cql_tests.TestCQLNodes2RF1.select_distinct_with_deletions_test are failing.

While in a mixed node state, they do 'SELECT DISTINCT k FROM t1' on this table
CREATE TABLE t1 (k int PRIMARY KEY, c int, v int)

More rows than expected are returned. Here is the sample output of one of those queries. As you can see, there are duplicate values of k returned in a DISTINCT k query. Seems like a bug when communicating between the 2.2 and 3.0 node.

[Row(k=5), Row(k=1), Row(k=1), Row(k=8), Row(k=8), Row(k=2), Row(k=2), Row(k=4), Row(k=4), Row(k=7), Row(k=7), Row(k=6), Row(k=6), Row(k=9), Row(k=9), Row(k=3), Row(k=3)]