[CASSANDRA-19688] SAI support for BETWEEN operator

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 5.1
• Component/s: CQL/Syntax, Feature/SAI
• Epic Link: Storage Attached Indexes (Phase 3)
• Change Category: Semantic
• Complexity: Normal
• Platform: All

Source Control Link

https://github.com/apache/cassandra/commit/bddaa4409fc4cb83394c2963a1028bcfb9dce733

Test and Documentation Plan

expanding CQL test coverage for BETWEEN

• Assignee: Arun Ganesh
• Reporter: Caleb Rackliffe

Authors

Arun Ganesh, Caleb Rackliffe

Reviewers

Caleb Rackliffe, Zhao Yang

• Created: 06/Jun/24 19:07
• Updated: 23/Sep/24 15:51
• Resolved: 05/Sep/24 17:10

Description

The new CQL BETWEEN operator should map pretty neatly to SAI’s internal RANGE operator for numeric indexes. There’s no reason we shouldn’t support it.

Issue Links

• causes: CASSANDRA-19938 Failed test: replica_side_filtering_test.TestSecondaryIndexes test_complementary_deletion_with_limit_on_clustering_key_column
• is related to: CASSANDRA-19604 Add support for BETWEEN operator
• links to: GitHub Pull Request #3433