[ https://issues.apache.org/jira/browse/CASSANDRA-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13931506#comment-13931506 ]
Sylvain Lebresne commented on CASSANDRA-5708: --------------------------------------------- I would maybe tend with the latter behavior too, as making 'IF EXISTS' mean 'IF the row EXISTS' in all cases feels a bit more consistent. Besides, we should probably add non-equal conditions in the short term, at which point the former behavior will be expressible by: {noformat} DELETE v FROM foo WHERE k=0 IF v != null {noformat} > Add DELETE ... IF EXISTS to CQL3 > -------------------------------- > > Key: CASSANDRA-5708 > URL: https://issues.apache.org/jira/browse/CASSANDRA-5708 > Project: Cassandra > Issue Type: Improvement > Reporter: Sylvain Lebresne > Assignee: Tyler Hobbs > Priority: Minor > Fix For: 2.0.7 > > > I've been slightly lazy in CASSANDRA-5443 and didn't added a {{DELETE .. IF > EXISTS}} syntax to CQL because it wasn't immediately clear what was the > correct condition to use for the "IF EXISTS". But at least for CQL3 tables, > this is in fact pretty easy to do using the row marker so we should probably > add it. -- This message was sent by Atlassian JIRA (v6.2#6252)