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

Multi-index query incorrectly returns 0 rows

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Feature/SASI
    • Labels:
      None
    • Environment:

      3.9.0 on linux & osx

    • Severity:
      Normal

      Description

      Setup:

      create table test1(id1 text PRIMARY KEY, val1 text, val2 text);
      create custom index test1_idx_val1 on test1(val1) using 'org.apache.cassandra.index.sasi.SASIIndex';
      create custom index test1_idx_val2 on test1(val2) using 'org.apache.cassandra.index.sasi.SASIIndex';
      
      insert into test1(id1, val1, val2) values ('1', '1val1', '1val2');
      insert into test1(id1, val1, val2) values ('2', '~~', '2val2');
      

      Queries:

      (1) select * from test1 where val1 = '~~';
      (2) select * from test1 where val1 < '~~' allow filtering;
      (3) select * from test1 where val2 = '1val2';
      (4) select * from test1 where val1 < '~~' and val2 = '1val2' allow filtering;
      

      1, 2, and 3 all work correctly. 4 does not work.

      2, 3, and 4 should return the same row (id1='1'); 2 and 3 do, 4 returns 0 rows.

        Attachments

          Activity

            People

            • Assignee:
              ifesdjeen Alex Petrov
              Reporter:
              voytek.jarnot Voytek Jarnot
              Authors:
              Alex Petrov
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: