cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Yaskevich (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-2566) CQL: Batch Updates: some consistency levels not working
Date Mon, 16 May 2011 21:57:47 GMT

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

Pavel Yaskevich updated CASSANDRA-2566:
---------------------------------------

    Attachment: CASSANDRA-2566.patch

Added missing consistency levels to CQL grammar.

> CQL: Batch Updates: some consistency levels not working
> -------------------------------------------------------
>
>                 Key: CASSANDRA-2566
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2566
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 0.8.1
>            Reporter: Cathy Daw
>            Assignee: Pavel Yaskevich
>              Labels: cql
>         Attachments: CASSANDRA-2566.patch
>
>
> Testing the batch updates, and running into some issues with different consistency levels
> +*Summary*+
> * UNTESTED: CONSISTENCY ANY
> * PASS: CONSISTENCY  ONE
> * PASS: CONSISTENCY  QUORUM
> * PASS: CONSISTENCY  ALL
> * CQL ERROR: CONSISTENCY  LOCAL_QUORUM
> * CQL ERROR: CONSISTENCY  EACH_QUORUM
>  
> +*Test Setup*+
> {code}
> CREATE KEYSPACE cqldb with strategy_class =  'org.apache.cassandra.locator.SimpleStrategy'
 
> and strategy_options:replication_factor=1;
> use cqldb;
> CREATE COLUMNFAMILY users (KEY varchar PRIMARY KEY, password varchar, gender varchar,

> session_token varchar, state varchar, birth_year bigint);
> INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user1', 'ch@ngem3',
'f', 'CA', '1971');
> INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user2', 'ch@ngem3',
'f', 'CA', '1972');
> INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user3', 'ch@ngem3',
'f', 'CA', '1973');
> {code}
> +*Bug Details*+
> *CONSISTENCY LOCAL_QUORUM*
> {code}
> BEGIN BATCH USING CONSISTENCY  LOCAL_QUORUM
> UPDATE users SET state = 'UT' WHERE KEY = 'user1';
> UPDATE users SET state = 'UT' WHERE KEY = 'user2';
> UPDATE users SET state = 'UT' WHERE KEY = 'user3';
> APPLY BATCH
> cqlsh>  Bad Request: line 1:31 mismatched input 'LOCAL_QUORUM' expecting K_LEVEL
> {code}
> *CONSISTENCY EACH_QUORUM*
> {code}
> BEGIN BATCH USING CONSISTENCY  EACH_QUORUM
> UPDATE users SET state = 'TX' WHERE KEY = 'user1';
> UPDATE users SET state = 'TX' WHERE KEY = 'user2';
> UPDATE users SET state = 'TX' WHERE KEY = 'user3';
> APPLY BATCH
> cqlsh> Bad Request: line 1:31 mismatched input 'EACH_QUORUM' expecting K_LEVEL
> {code}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message