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

counter: update delete Command conflict

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Not A Problem
    • None
    • None
    • None
    • Normal

    Description

      ----------------------------------------------------
      CREATE TABLE expendbulk (
      key text,
      expend counter,
      PRIMARY KEY (key)
      );
      --------------------------------------------------------
      2. insert data:
      cqlsh:lottery> UPDATE expendbulk SET expend = expend + 1 WHERE key = 'TJ';
      cqlsh:lottery> SELECT * FROM expendbulk ;

      key | expend
      ----+-------
      TJ | 1
      -----------------------------------------------------------------------------------------
      3.delete data:
      cqlsh:lottery> DELETE from expendbulk where key = 'TJ';
      cqlsh:lottery> SELECT * FROM expendbulk ;

      (0 rows)
      ----------------------------------------------------------------------------------
      4.insert data:
      cqlsh:lottery> UPDATE expendbulk SET expend = expend + 1 WHERE key = 'TJ';
      cqlsh:lottery> SELECT * FROM expendbulk ;

      (0 rows)
      ----------------------------------------------------------------------------------------

      After deleting the data can not be inserted.

      Attachments

        Activity

          People

            Unassigned Unassigned
            yangqiju yangqiju
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: