Ashot Golovenko created CASSANDRA-7379: ------------------------------------------
Summary: updating a row with composite key with a null value removes the entire row Key: CASSANDRA-7379 URL: https://issues.apache.org/jira/browse/CASSANDRA-7379 Project: Cassandra Issue Type: Bug Components: Core Reporter: Ashot Golovenko Priority: Critical create a table CREATE TABLE relation ( u1 bigint, u2 bigint, mf int, PRIMARY KEY (u1, u2)); insert value: UPDATE facebook_user_relation SET mf = 1 WHERE u1 = 1 and u2 = 2; SELECT * from relation ; u1 | u2 | mf ----+----+---- 1 | 2 | 1 insert null value: UPDATE relation SET mf = null WHERE u1 = 1 and u2 = 2; SELECT * from relation ; (0 rows) <--- WRONG! The INSERT statement however works: INSERT INTO relation (u1, u2, mf) VALUES (1, 2, null); SELECT * from relation ; u1 | u2 | mf ----+----+------ 1 | 2 | null (1 rows) -- This message was sent by Atlassian JIRA (v6.2#6252)