Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-11805

Row deleted when value updated to null

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Not A Problem
    • Fix Version/s: None
    • Component/s: Legacy/Core
    • Labels:
      None
    • Environment:

      C* 3.5, both single node and cluster, C* 3.6 snapshot single node

    • Severity:
      Normal

      Description

      It seems that the behaviour of the value update to null differs when row is created by insert or update. When it is inserted the row stays and the value is null, when updated the row is deleted.

      Simple example:

      Inserts:

      create table aaa (a ascii, b ascii, c ascii, primary key (a,b));

      insert into aaa (a,b,c) values ('a','b','c');
      insert into aaa (a,b,c) values ('a','c','d');
      insert into aaa (a,b,c) values ('a','d','e');

      select * from aaa;

      a | b | c
      -----
      a | b | c
      a | c | d
      a | d | e

      update aaa set c = null where a='a' and b='b';

      select * from aaa;

      a | b | c
      --------
      a | b | null
      a | c | d
      a | d | e

      Updates:

      create table bbb (a ascii, b ascii, c ascii, primary key (a,b));

      update bbb set c = 'c' where a='a' and b='b';
      update bbb set c = 'd' where a='a' and b='c';
      update bbb set c = 'e' where a='a' and b='d';

      select * from bbb;

      a | b | c
      -----
      a | b | c
      a | c | d
      a | d | e

      update bbb set c = null where a='a' and b='b';

      select * from bbb;

      a | b | c
      -----
      a | c | d
      a | d | e

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                shinigami Jaroslav Kamenik
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: