cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sam Tunnicliffe (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-11397) LIKE query on clustering column index returns incorrect results
Date Tue, 22 Mar 2016 12:04:25 GMT

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

Sam Tunnicliffe updated CASSANDRA-11397:
----------------------------------------
    Labels: sasi  (was: )
    Status: Patch Available  (was: Open)

||branch||testall||dtest||
|[11397-3.5|https://github.com/beobal/cassandra/tree/11397-3.5]|[testall|http://cassci.datastax.com/view/Dev/view/beobal/job/beobal-11397-3.5-testall]|[dtest|http://cassci.datastax.com/view/Dev/view/beobal/job/beobal-11397-3.5-dtest]|
|[11397-trunk|https://github.com/beobal/cassandra/tree/11397-trunk]|[testall|http://cassci.datastax.com/view/Dev/view/beobal/job/beobal-11397-trunk-testall]|[dtest|http://cassci.datastax.com/view/Dev/view/beobal/job/beobal-11397-trunk-dtest]|


> LIKE query on clustering column index returns incorrect results
> ---------------------------------------------------------------
>
>                 Key: CASSANDRA-11397
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11397
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Sam Tunnicliffe
>            Assignee: Sam Tunnicliffe
>              Labels: sasi
>             Fix For: 3.5
>
>
> The way that {{ClusteringIndexFilter}} and {{RowFilter}} are constructed when a {{LIKE}}
restriction on a clustering column is present is incorrect. For example:
> {code}
> cqlsh> create table ks.t1 (k text, c1 text, c2 text, c3 text, v text, primary key
(k,c1,c2,c3));
> cqlsh> create custom index on ks.t1(c2) using 'org.apache.cassandra.index.sasi.SASIIndex';
> cqlsh> select * from ks.t1;
>  k | c1 | c2 | c3 | v
> ---+----+----+----+-----
>  a | ba | ca | da | val
>  a | bb | cb | db | val
>  a | bc | cc | dc | val
> (3 rows)
>  
> cqlsh> select * from ks.t1 where c1 = 'ba' and c3 = 'da' and c2 LIKE 'c%' ALLOW FILTERING;
>  k | c1 | c2 | c3 | v
> ---+----+----+----+---
> (0 rows)
> {code}



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

Mime
View raw message