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

Static columns with IF NOT EXISTS don't always work as expected

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Fixed
    • Fix Version/s: 2.0.7
    • Component/s: None
    • Labels:
      None
    • Severity:
      Low

      Description

      Given:

      CREATE TABLE test (
          id int,
          k text,
          version int static,
          v int,
          PRIMARY KEY (id, k)
      )
      
      INSERT INTO test(id, k, v) VALUES (1, 'foo', 'foo')
      

      the following conditional update should not apply:

      INSERT INTO test(id, k, version) VALUES (1, 'foo', 1) IF NOT EXISTS
      

      since said query involves the clustering column and the CQL row with said clustering column already exists. It does currently apply however.

        Attachments

        1. 6873.txt
          5 kB
          Sylvain Lebresne

          Activity

            People

            • Assignee:
              slebresne Sylvain Lebresne
              Reporter:
              slebresne Sylvain Lebresne
              Authors:
              Sylvain Lebresne
              Reviewers:
              Aleksey Yeschenko
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: