[CASSANDRA-9838] Unable to update an element in a static list

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.10, 2.2.2, 3.0.0 rc1

Environment

Cassandra 2.1.5 on Linux

• Severity: Normal
• Assignee: Unassigned
• Reporter: Mahesh Datt

Reviewers

Benjamin Lerer

• Created: 16/Jul/15 21:27
• Updated: 16/Apr/19 09:31
• Resolved: 09/Sep/15 20:28

Description

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!

Issue Links

• is duplicated by: CASSANDRA-10279 Inconsistent update/delete behavior for static lists vs lists