[
https://issues.apache.org/jira/browse/CASSANDRA-7891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Patrick McFadin updated CASSANDRA-7891:
---------------------------------------
Description:
Create the following data model:
{noformat}
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'});
{noformat}
When trying to select a sub-field in the name type:
{noformat}
SELECT name.lastname FROM users WHERE id=62c36092-82a1-3a00-93d1-46196ee77204;
{noformat}
You get the following error:
{noformat}
list index out of range
{noformat}
was:
Create the following data model:
{noformat}
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'});
{noformat}
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
}}
> Select an element inside a UDT throws an index error
> ----------------------------------------------------
>
> Key: CASSANDRA-7891
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7891
> Project: Cassandra
> Issue Type: Bug
> Reporter: Patrick McFadin
> Fix For: 2.1.1
>
>
> Create the following data model:
> {noformat}
> 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'});
> {noformat}
> When trying to select a sub-field in the name type:
> {noformat}
> SELECT name.lastname FROM users WHERE id=62c36092-82a1-3a00-93d1-46196ee77204;
> {noformat}
> You get the following error:
> {noformat}
> list index out of range
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
