Details
-
Bug
-
Status: Open
-
Normal
-
Resolution: Unresolved
-
None
-
None
-
3.9.0 on linux & osx
-
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.