007reader created CASSANDRA-8810: ------------------------------------ Summary: incorrect indexing of list collection Key: CASSANDRA-8810 URL: https://issues.apache.org/jira/browse/CASSANDRA-8810 Project: Cassandra Issue Type: Bug Components: Core Environment: windows 8 Reporter: 007reader Fix For: 2.1.2
in a table with one indexed field type list<text> data retrieval is not working properly: I have a simple table with an indexed list<text> 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<text>); create index on test (parts); insert into test (whole,parts) values('a', ['a']); insert into test (whole,parts) values('b', ['b']); insert into test (whole,parts) values('c', ['c']); insert into test (whole,parts) values('a.a', ['a','a']); insert into test (whole,parts) values('a.b', ['a','b']); insert into test (whole,parts) values('a.c', ['a','c']); insert into test (whole,parts) values('b.a', ['b','a']); insert into test (whole,parts) values('b.b', ['b','b']); insert into test (whole,parts) values('b.c', ['b','c']); insert into test (whole,parts) values('c.c', ['c','c']); insert into test (whole,parts) values('c.b', ['c','b']); insert into test (whole,parts) values('c.a', ['c','a']); This is expected behavior: ------------------------------------------ select * from test where parts contains 'a' ALLOW FILTERING; whole | parts -------+------------ a | ['a'] b.a | ['b', 'a'] a.c | ['a', 'c'] a.b | ['a', 'b'] a.a | ['a', 'a'] c.a | ['c', 'a'] >From the following query I expect a subset of the previous query result, but >it returns no data --------------------------------------------------- select * from test where parts contains 'a' and parts contains 'b' ALLOW FILTERING; whole | parts -------+------- -- This message was sent by Atlassian JIRA (v6.3.4#6332)