Sylvain Lebresne created CASSANDRA-5715:
-------------------------------------------
Summary: CAS on 'primary key only' table
Key: CASSANDRA-5715
URL: https://issues.apache.org/jira/browse/CASSANDRA-5715
Project: Cassandra
Issue Type: Improvement
Reporter: Sylvain Lebresne
Priority: Minor
Given a table with only a primary key, like
{noformat}
CREATE TABLE test (k int PRIMARY KEY)
{noformat}
there is currently no way to CAS a row in that table into existing because:
# INSERT doesn't currently support IF
# UPDATE has no way to update such table
So we should probably allow IF conditions on INSERT statements.
In addition (or alternatively), we could work on allowing UPDATE to update such
table. One motivation for that could be to make UPDATE always be more general
to INSERT. That is currently, there is a bunch of operation that INSERT cannot
do (counter increments, collection appends), but that "primary key table" case
is, afaik, the only case where you *need* to use INSERT. However, because CQL
forces segregation of PK value to the WHERE clause and not to the SET one, the
only syntax that I can see work would be:
{noformat}
UPDATE WHERE k=0;
{noformat}
which maybe is too ugly to allow?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
