[CASSANDRA-7891] Select an element inside a UDT throws an index error

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.1, 2.2.0 beta 1
• Labels: qa-resolved
• Severity: Normal
• Since Version: 2.1.1
• Assignee: Philip Thompson
• Reporter: Patrick McFadin

Authors

Philip Thompson

Reviewers

Tom Hobbs

• Tester: Philip Thompson
• Created: 05/Sep/14 18:48
• Updated: 16/Apr/19 09:31
• Resolved: 19/Sep/14 21:06

Description

Create the following data model:

CREATE TYPE address (
street text,
city text,
zip_code int,
phones set<text>
 );
 
CREATE TYPE fullname (
firstname text,
lastname text
);

CREATE TABLE users (
id uuid PRIMARY KEY,
name FROZEN <fullname>,
addresses map<text, FROZEN <address>>
);

INSERT INTO users (id, name) 
VALUES (62c36092-82a1-3a00-93d1-46196ee77204, {firstname: 'Marie-Claude', lastname: 'Josset'});

When trying to select a sub-field in the name type:

SELECT name.lastname FROM users WHERE id=62c36092-82a1-3a00-93d1-46196ee77204;

You get the following error:

list index out of range

Issue Links

• is broken by: CASSANDRA-6910 Better table structure display in cqlsh
• is related to: CASSANDRA-8155 confusing error when erroneously querying map secondary index