[CASSANDRA-7506] querying secondary index using complete collection should warn/error

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.10, 2.1.1
• Component/s: Feature/2i Index
• Labels: qa-resolved

Environment

cassandra 2.1.0-rc2, java 1.7.0_60

• Severity: Normal
• Assignee: Tom Hobbs
• Reporter: Russ Hatch

Authors

Tom Hobbs

Reviewers

Sylvain Lebresne

• Tester: Russ Hatch
• Created: 07/Jul/14 20:16
• Updated: 16/Apr/19 09:31
• Resolved: 19/Aug/14 16:22

Description

Cassandra does not seem to support querying a set literal like so:

select * from testtable where pkey='foo' and mycollection = {'one', 'two'};

We currently don't let the user know this query is problematic, rather we just return no rows.

To reproduce:

create keyspace test with replication = {'class': 'SimpleStrategy', 'replication_factor':1} ;

use test ;

create table testtable (pkey text PRIMARY KEY, mycollection set<text>);

create index on testtable (mycollection);

insert into testtable (pkey, mycollection) VALUES ( 'foo', {'one','two'};

cqlsh:test> select * from testtable where pkey='foo' and mycollection = {'one', 'two'};

(0 rows)