[jira] [Commented] (CASSANDRA-13105) Multi-index query incorrectly returns 0 rows

["Voytek Jarnot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-13105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15805633#comment-15805633 ] 

Voytek Jarnot commented on CASSANDRA-13105:
-------------------------------------------

Even stranger, I can add a 5th query that does work:

{code}
(5) select * from test1 where val1 < '~~' AND val2 < '1val3' allow filtering;
{code}

Changing the val2 evaluation from '=' to '<' makes the query work.

I am now even further at a loss: query 5 works, query 4 does not.

> Multi-index query incorrectly returns 0 rows
> --------------------------------------------
>
>                 Key: CASSANDRA-13105
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13105
>             Project: Cassandra
>          Issue Type: Bug
>          Components: sasi
>         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)