[CASSANDRA-19938] Failed test: replica_side_filtering_test.TestSecondaryIndexes test_complementary_deletion_with_limit_on_clustering_key_column

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 5.1
• Component/s: Test/dtest/python
• Bug Category: Code - Bug - Unclear Impact
• Severity: Low
• Complexity: Normal
• Discovered By: DTest
• Platform: All
• Since Version: NA

Source Control Link

https://github.com/apache/cassandra/commit/9da4bd412d1c7d34048241806cd572862b494648

Test and Documentation Plan

n/a

• Assignee: Caleb Rackliffe
• Reporter: Stefan Miklosovic

Authors

Caleb Rackliffe

Reviewers

Stefan Miklosovic

• Created: 20/Sep/24 16:56
• Updated: 24/Sep/24 03:35
• Resolved: 24/Sep/24 03:35

Description

I noticed these two started to always fail in trunk

replica_side_filtering_test.TestSecondaryIndexes test_complementary_deletion_with_limit_on_clustering_key_column
replica_side_filtering_test.TestSecondaryIndexes test_complementary_deletion_with_limit_on_partition_key_column_with_not_empty_partitions

Fails on

        >       assert list_res == [], "Expected nothing from {}, but got {}".format(query, list_res)
        E       AssertionError: Expected nothing from SELECT * FROM t WHERE c = 0 LIMIT 1, but got [[1, 0]]

and

        >       assert list_res == [], "Expected nothing from {}, but got {}".format(query, list_res)
        E       AssertionError: Expected nothing from SELECT * FROM t WHERE k1 = 0 LIMIT 1, but got [[0, 1, 10, 100]]

Issue Links

• is caused by: CASSANDRA-19688 SAI support for BETWEEN operator
• links to: GitHub Pull Request #3561