[jira] [Created] (CASSANDRA-7506) querying secondary index using equals with set literal should give a message

[Russ Hatch (JIRA)]

Russ Hatch created CASSANDRA-7506:
-------------------------------------

             Summary: querying secondary index using equals with set literal 
should give a message
                 Key: CASSANDRA-7506
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7506
             Project: Cassandra
          Issue Type: Bug
         Environment: cassandra 2.1.0-rc2, java 1.7.0_60
            Reporter: Russ Hatch


Cassandra does not seem to support querying a set literal like so:
{noformat}
select * from testtable where pkey='foo' and mycollection = {'one', 'two'};
{noformat}
We currently don't let the user know this query is problematic, rather we just 
return no rows.

To reproduce:
{noformat}
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)
{noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)