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

["Mahesh Datt (JIRA)" <ji...@apache.org>]

Mahesh Datt created CASSANDRA-9838:
--------------------------------------

             Summary: 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


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

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 ;

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)