[CASSANDRA-8155] confusing error when erroneously querying map secondary index

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Duplicate
• Fix Version/s: 2.1.2
• Component/s: Feature/2i Index
• Labels: cqlsh lhf
• Severity: Low
• Assignee: Tom Hobbs
• Reporter: Russ Hatch

Authors

Tom Hobbs

Reviewers

Sylvain Lebresne

• Tester: Russ Hatch
• Created: 20/Oct/14 21:55
• Updated: 16/Apr/19 09:31
• Resolved: 23/Oct/14 15:54

Description

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:

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'});

Now try to query the existing values index by key:

cqlsh:test> select * from foo where categories contains key 'firstkey';
list index out of range

Issue Links

• duplicates: CASSANDRA-8147 Secondary indexing of map keys does not work properly when mixing contains and contains_key
• relates to: CASSANDRA-7891 Select an element inside a UDT throws an index error