[jira] [Updated] (CASSANDRA-9838) Unable to update an element in a static list

["Brett Snyder (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-9838?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brett Snyder updated CASSANDRA-9838:
------------------------------------
    Attachment: cassandra-2.1-9838.txt

Patch against 2.1.x

> Unable to update an element in a static list
> --------------------------------------------
>
>                 Key: CASSANDRA-9838
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9838
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: Cassandra 2.1.5 on Linux
>            Reporter: Mahesh Datt
>             Fix For: 2.1.x
>
>         Attachments: cassandra-2.1-9838.txt
>
>
> I created a table in cassandra  (my_table) which has a static list column sizes_list. 
> I created a new row and initialized the list sizes_list as having one element. 
> {{UPDATE my_table SET sizes_list = sizes_list + [0] WHERE view_id = 0x01}}
> Now I m trying to update the element at index '0' with a statement like this
> {code}insert into my_table (my_id, is_deleted , col_id1, col_id2) values (0x01, False, 0x00, 0x00);
> UPDATE my_table SET sizes_list[0] = 100 WHERE my_id = 0x01 ;
> {code}
> Now I see an error like this: 
> {{InvalidRequest: code=2200 [Invalid query] message="List index 0 out of bound, list has size 0"}}
> If I change my list to a non-static list, it works fine! 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)