[CASSANDRA-6951] update query deletes instead of update, upgraded to 2.0.6

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Not A Problem

Environment

ubuntu 12.04 on ec2

• Severity: Normal
• Since Version: 2.0.6
• Assignee: Unassigned
• Reporter: Pardeep Singh
• Created: 28/Mar/14 22:30
• Updated: 16/Apr/19 09:31
• Resolved: 28/Mar/14 23:45

Description

I'm showing two examples below to show what happens. I'm using update, but technically it's an insert. This worked in the previous version, which I don't remember but it was 1.2+

cqlsh:tagloom> update user_timeline set d=null WHERE uid='aa' and pid='aa';
cqlsh:tagloom> select * from user_timeline where uid='aa' limit 4;
(0 rows)

cqlsh:tagloom> update user_timeline set d='a' WHERE uid='aa' and pid='aa';
cqlsh:tagloom> select * from user_timeline where uid='aa' limit 4;
uid | pid | d
---------
aa | aa | a
(1 rows)

I run it again:
cqlsh:tagloom> update user_timeline set d=null WHERE uid='aa' and pid='aa';
cqlsh:tagloom> select * from user_timeline where uid='aa' limit 4;
(0 rows)

Seems like it's deleting the row. Was there a change that made the above results possible or is it a bug?

Issue Links

• is duplicated by: CASSANDRA-7379 updating a row with compound key with a null value removes the entire row