Voytek Jarnot created CASSANDRA-13105:
-----------------------------------------
Summary: Multi-index query incorrectly returns 0 rows
Key: CASSANDRA-13105
URL: https://issues.apache.org/jira/browse/CASSANDRA-13105
Project: Cassandra
Issue Type: Bug
Environment: 3.9.0 on linux & osx
Reporter: Voytek Jarnot
Setup:
{code}
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');
{code}
Queries:
{code}
(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;
{code}
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
