[CASSANDRA-11389] Case sensitive in LIKE query althogh index created with false

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Not A Bug
• Fix Version/s: 3.11.5
• Component/s: Feature/SASI
• Labels: sasi
• Assignee: Pavel Yaskevich
• Reporter: Alon Levi

Authors

Pavel Yaskevich

• Created: 21/Mar/16 12:55
• Updated: 01/Aug/21 11:28
• Resolved: 01/Apr/16 21:55

Description

I created an index on user's first name as following:

CREATE CUSTOM INDEX ON users (first_name) USING 'org.apache.cassandra.index.sasi.SASIIndex'
with options = {
'mode' : 'CONTAINS',
'case_sensitive' : 'false'
};

This is the data I have in my table
user_id | first_name | last_name
-----------------------------------------------------------------------------
daa312ae-ecdf-4eb4-b6e9-206e33e5ca24 | Shlomo | Cohen
ab38ce9d-2823-4e6a-994f-7783953baef1 | Elad | Karakuli
5e8371a7-3ed9-479f-9e4b-e4a07c750b12 | Alon | Levi
ae85cdc0-5eb7-4f08-8e42-2abd89e327ed | Gil | Elias

Although i mentioned the option 'case_sensitive' : 'false'
when I run this query :

select user_id, first_name from users where first_name LIKE '%shl%';

The query returns no results.
However, when I run this query :

select user_id, first_name from users where first_name LIKE '%Shl%';

The query returns the right results,
and the strangest thing is when I run this query:

select user_id, first_name from users where first_name LIKE 'shl%';

suddenly the query is no more case sensitive and the results are fine.