[
https://issues.apache.org/jira/browse/CASSANDRA-8155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tyler Hobbs updated CASSANDRA-8155:
-----------------------------------
Attachment: 8155.txt
8155.txt fixes the cqlsh grammar and pulls out some of the improved secondary
index validation from the patch on CASSANDRA-7859.
> 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
> Attachments: 8155.txt
>
>
> 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)
