[CASSANDRA-19604] Add support for BETWEEN operator

• Type: Improvement
• Status: Review In Progress
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: CQL/Interpreter
• Change Category: Semantic
• Complexity: Normal
• Platform: All

Test and Documentation Plan

The patch add unit tests that cover the new functionality.

• Assignee: Simon Chess
• Reporter: Benjamin Lerer

Authors

Simon Chess

Reviewers

Benjamin Lerer, Ekaterina Dimitrova

• Created: 01/May/24 07:17
• Updated: 4 days ago 00:42

Description

CQL support the >= and <= but does not support yet the BETWEEN operator. After CASSANDRA-19341 adding new operators should be much simpler and safer than it use to be.
For the scope of this ticket BETWEEN support should be added for WHERE clauses of SELECT and DELETE queries (for single column and multi-column restrictions). NOT BETWEEN should be added and should be supported everywhere BETWEEN is.

Additional information for newcomers:
Parts that will need to be modified:

• Lexer.g and Parser.g to add support for the new keyword and syntax
• The Operator.class to add the new BETWEEN operator
• Unit tests in SelectSingleColumnRelationTest and SelectMultiColumnRelationTest classes for the different types of columns (partition key, clustering, static and regular).
• CQLSH auto completion in cql3handling.py and test for it in test_cqlsh_completion.py
• Update the documentation

Of course this is just an overview and some other parts might have to be changed as well.

Issue Links

• links to: GitHub Pull Request #3301