You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Patrick McFadin (JIRA)" <ji...@apache.org> on 2014/09/05 20:51:28 UTC
[jira] [Updated] (CASSANDRA-7891) Select an element inside a UDT
throws an index error
[ 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:
{{
SELECT name.lastname FROM users WHERE id=62c36092-82a1-3a00-93d1-46196ee77204;
}}
You get the following error:
{{
list index out of range
}}
was:
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
}}
> 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:
> {{
> SELECT name.lastname FROM users WHERE id=62c36092-82a1-3a00-93d1-46196ee77204;
> }}
> You get the following error:
> {{
> list index out of range
> }}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)