Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-11397

LIKE query on clustering column index returns incorrect results

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 3.5
    • None
    • Normal

    Description

      The way that ClusteringIndexFilter and RowFilter are constructed when a LIKE restriction on a clustering column is present is incorrect. For example:

      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)
      

      Attachments

        Activity

          People

            samt Sam Tunnicliffe
            samt Sam Tunnicliffe
            Sam Tunnicliffe
            Jordan West
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: