You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cassandra.apache.org by "Arunkumar M (JIRA)" <ji...@apache.org> on 2016/08/31 06:32:20 UTC

[jira] [Assigned] (CASSANDRA-12573) SASI index. No results for '%foo%bar%'-like search pattern.

     [ https://issues.apache.org/jira/browse/CASSANDRA-12573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arunkumar M reassigned CASSANDRA-12573:
---------------------------------------

    Assignee: Arunkumar M

> SASI index. No results for '%foo%bar%'-like search pattern. 
> ------------------------------------------------------------
>
>                 Key: CASSANDRA-12573
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12573
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Mikhail Krupitskiy
>            Assignee: Arunkumar M
>
> Cassandra 3.7.
> 1) Create index for String column:
> {noformat}
> CREATE CUSTOM INDEX index_name ON Table (Column) USING 'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode': 'CONTAINS'};
> {noformat}
> 2) Insert some rows where Column contains 'foo' and 'bar'. E.g. '1foo2bar3'.
> 3) Try to query rows where Column contains 'foo' and 'bar'.
> Request {noformat}select * from Table where Column like '%foo%bar%'{noformat} returns *no* rows. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)