cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tyler Hobbs (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-7891) Select an element inside a UDT throws an index error
Date Fri, 19 Sep 2014 20:25:35 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-7891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14141236#comment-14141236
] 

Tyler Hobbs commented on CASSANDRA-7891:
----------------------------------------

I missed this on the first review, but the current fix will only work for the first item in
the select.  My suggestion would be to undo the current changes, and modify the {{<selector>}}
definition to include the subfield access syntax.

> 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
>            Assignee: Philip Thompson
>             Fix For: 2.1.1, 3.0
>
>         Attachments: 7891-2.txt, 7891.txt
>
>
> 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)

Mime
View raw message