[jira] [Commented] (CASSANDRA-9313) Clarify errors when attempting to write at SERIAL

["Wei Deng (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-9313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15073614#comment-15073614 ] 

Wei Deng commented on CASSANDRA-9313:
-------------------------------------

Does this mean the existing documentation here https://docs.datastax.com/en/cassandra/2.1/cassandra/dml/dml_config_consistency_c.html is totally inaccurate?

> Clarify errors when attempting to write at SERIAL
> -------------------------------------------------
>
>                 Key: CASSANDRA-9313
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9313
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL
>            Reporter: Brandon Williams
>            Priority: Minor
>             Fix For: 2.1.x
>
>
> [LOCAL_]SERIAL does not support writes, but the errors can be very confusing if you don't know this:
> {noformat}
> cqlsh:foo> INSERT INTO bar (foo ) VALUES ( 'foo' ) ;
> InvalidRequest: code=2200 [Invalid query] message="You must use conditional updates for serializable writes"
> cqlsh:foo> INSERT INTO bar (foo ) VALUES ( 'foo' ) if NOT EXISTS ;
> InvalidRequest: code=2200 [Invalid query] message="SERIAL is not supported as conditional update commit consistency. Use ANY if you mean "make sure it is accepted but I don't care how many replicas commit it for non-SERIAL reads""
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)