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

Allow LWT operation on static column with only partition keys

    XMLWordPrintableJSON

    Details

      Description

      Schema

      CREATE TABLE IF NOT EXISTS achilles_embedded.entity_with_static_column(
      id bigint,
      uuid uuid,
      static_col text static,
      value text,
      PRIMARY KEY(id, uuid));
      

      When trying to prepare the following query

      DELETE static_col FROM achilles_embedded.entity_with_static_column WHERE id=:id_Eq IF static_col=:static_col;
      

      I got the error DELETE statements must restrict all PRIMARY KEY columns with equality relations in order to use IF conditions, but column 'uuid' is not restricted

      Since the mutation only impacts the static column and the CAS check is on the static column, it makes sense to provide only partition key

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                carlyeks Carl Yeksigian
                Reporter:
                doanduyhai DuyHai Doan
                Authors:
                Carl Yeksigian
                Reviewers:
                Benjamin Lerer
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: