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)