You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2011/05/17 00:31:48 UTC
[jira] [Commented] (CASSANDRA-2566) CQL: Batch Updates: some
consistency levels not working
[ https://issues.apache.org/jira/browse/CASSANDRA-2566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13034385#comment-13034385 ]
Hudson commented on CASSANDRA-2566:
-----------------------------------
Integrated in Cassandra-0.8 #111 (See [https://builds.apache.org/hudson/job/Cassandra-0.8/111/])
update cql consistency levels
patch by pyaskevich; reviewed by jbellis for CASSANDRA-2566
> 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
> Fix For: 0.8.1
>
> 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