Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Fri, 17 Jul 2015 14:15:04 +0000 (UTC)
From: "Philip Thompson (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12845723.1437082079000.215971.1437142504669@Atlassian.JIRA>
In-Reply-To: <JIRA.12845723.1437082079000@Atlassian.JIRA>
References: <JIRA.12845723.1437082079000@Atlassian.JIRA>
 <JIRA.12845723.1437082079593@arcas>
Subject: [jira] [Updated] (CASSANDRA-9838) Unable to update an element in a
 static list
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Philip Thompson updated CASSANDRA-9838:
---------------------------------------
    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

{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! 

  was:
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! 


> 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
>
>
> 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)