cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikhail Krupitskiy (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-12573) SASI index. No results for '%foo%bar%'-like search pattern.
Date Tue, 30 Aug 2016 17:33:22 GMT
Mikhail Krupitskiy created CASSANDRA-12573:
----------------------------------------------

             Summary: 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


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)

Mime
View raw message