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

          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-9842 Inconsistent behavior for '= null' conditions on static columns

          • Normal -
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-11843 Improve test coverage for conditional deletes

          • Normal -
          • Resolved

          Activity

            People

              carlyeks Carl Yeksigian
              doanduyhai DuyHai Doan
              Carl Yeksigian
              Benjamin Lerer
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: