I am using Cassandra 2.1.2.
1) yes, it works fine with any single element of the list "contains 'b'"
and "contains 'c'"
2) if I add a second condition, it doesn't work
3) if I change list to set, it works properly, but doesn't work for my use
case because i may have duplicates
I files a Jira ticke
That should work. File a Jira. While release of Cassandra are you using?
There were some bugs is indexing for set collections; maybe that affected
list as well.
Out of curiosity, does a SELECT with only "contains 'b'" work?
Also, try using "set" rather than "list".
-- Jack Krupansky
On Sun, Feb
I have a simple table with an indexed list field, but it shows
unexpected behavior when I query the list. Am i doing something incorrect?
create table test (whole text PRIMARY KEY, parts list);
create index on test (parts);
insert into test (whole,parts) values('a', ['a']);
insert into test (whole