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

Allow LWT operation on static column with only partition keys

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment