[ https://issues.apache.org/jira/browse/CASSANDRA-11389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Yaskevich resolved CASSANDRA-11389. ----------------------------------------- Resolution: Not A Bug Assignee: Pavel Yaskevich > Case sensitive in LIKE query althogh index created with false > ------------------------------------------------------------- > > Key: CASSANDRA-11389 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11389 > Project: Cassandra > Issue Type: Improvement > Components: sasi > Reporter: Alon Levi > Assignee: Pavel Yaskevich > Priority: Minor > Labels: sasi > Fix For: 3.x > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)