[jira] [Comment Edited] (CASSANDRA-11389) Case sensitive in LIKE query althogh index created with false

["Pavel Yaskevich (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-11389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15217187#comment-15217187 ] 

Pavel Yaskevich edited comment on CASSANDRA-11389 at 3/30/16 1:14 AM:
----------------------------------------------------------------------

I think what is going on here is that "case_sensitive" is a feature of analyzer, indexes are not analyzed by default that's why index returns no results since that flag is simply ignored. To fix this you should set - either "analyzed": "true" or ‘analyzer_class’: ‘org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer’ in the index options.


was (Author: xedin):
I think what is going on here is that "case_sensetive" is a feature of analyzer, indexes are not analyzed by default that's why index returns no results since that flag is simply ignored. To fix this you should set - either "analyzed": "true" or ‘analyzer_class’: ‘org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer’ in the index options.

> 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: Bug
>          Components: sasi
>            Reporter: Alon Levi
>            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)