[ 
https://issues.apache.org/jira/browse/CASSANDRA-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Tyler Hobbs reassigned CASSANDRA-8155:
--------------------------------------

    Assignee: Tyler Hobbs

> confusing error when erroneously querying map secondary index
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-8155
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8155
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Russ Hatch
>            Assignee: Tyler Hobbs
>            Priority: Minor
>              Labels: cqlsh, lhf
>
> With a secondary index on values, attempting to query by key returns an error 
> message of "list index out of range".
> This is kinda a similar issue to CASSANDRA-8147 (but that scenario results in 
> no error when there probably should be one).
> To repro:
> {noformat}
> cqlsh:test> CREATE TABLE test.foo (
>         ...     id1 text,
>         ...     id2 text,
>         ...     categories map<text, text>,
>         ...     PRIMARY KEY (id1, id2));
> cqlsh:test> CREATE INDEX foo_categories_idx ON test.foo (categories);
> cqlsh:test> insert into foo (id1, id2, categories) values ('foo', 'bar', 
> {'firstkey':'one', 'secondkey':'two'});
> {noformat}
> Now try to query the existing values index by key:
> {noformat}
> cqlsh:test> select * from foo where categories contains key 'firstkey';
> list index out of range
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to