[CASSANDRA-17198] Allow to filter using LIKE predicates

• Type: Improvement
• Status: Review In Progress
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: CQL/Syntax
• Labels: AdventCalendar2021 lhf
• Change Category: Semantic
• Complexity: Low Hanging Fruit
• Platform: All

Test and Documentation Plan

https://github.com/apache/cassandra/pull/1373

• Assignee: Kanthi Subramanian
• Reporter: Benjamin Lerer

Authors

Kanthi Subramanian

Reviewers

[e-mail], Berenguer Blasi

• Created: 08/Dec/21 15:08
• Updated: 19/Apr/24 15:18

Description

LIKE predicates can only be used with the SASI indices. In several usecases (e.g. querying the settings virtual table) it makes sense to support them for filtering.

Additional information for newcomers:

There are some checks in the StatementRestrictions constructor and on LikeRestriction that need to be removed for allowing filtering using LIKE on clustering and regular columns.
For filtering on partition columns the needFiltering methods in PartitionKeySingleRestrictionSet will need to be modified to return true when LIKE predicate are used.
The unit tests should go in SelectTest.

Issue Links

• incorporates: CASSANDRA-19574 LIKE_MATCHES should be an equality
• is related to: CASSANDRA-18493 SAI - LIKE prefix/suffix support