[ 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)