[ https://issues.apache.org/jira/browse/CASSANDRA-10532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15089895#comment-15089895 ]
Carl Yeksigian commented on CASSANDRA-10532: -------------------------------------------- I pushed up a new version. The 2 important versions are [2.1|https://github.com/carlyeks/cassandra/tree/ticket/10532/2.1] and [3.0|https://github.com/carlyeks/cassandra/tree/ticket/10532/3.0], the rest were just merges. While trying to fix the 3.0 test to output about the static columns, I realized that we don't need to separate out the partition keys from the primary keys, as they are checked elsewhere, and we also don't need to add a special message since there is no way to get that far when you haven't specified the partition key. ||2.1||3.3|| |[branch|https://github.com/carlyeks/cassandra/tree/ticket/10532/2.1]|[branch|https://github.com/carlyeks/cassandra/tree/ticket/10532/3.3]| |[utest|http://cassci.datastax.com/view/Dev/view/carlyeks/job/carlyeks-ticket-10532-2.1-testall/]|[utest|http://cassci.datastax.com/view/Dev/view/carlyeks/job/carlyeks-ticket-10532-3.3-testall/]| |[dtest|http://cassci.datastax.com/view/Dev/view/carlyeks/job/carlyeks-ticket-10532-2.1-dtest/]|[dtest|http://cassci.datastax.com/view/Dev/view/carlyeks/job/carlyeks-ticket-10532-3.3-dtest/]| > Allow LWT operation on static column with only partition keys > ------------------------------------------------------------- > > Key: CASSANDRA-10532 > URL: https://issues.apache.org/jira/browse/CASSANDRA-10532 > Project: Cassandra > Issue Type: Improvement > Components: CQL > Environment: C* 2.2.0 > Reporter: DOAN DuyHai > Assignee: Carl Yeksigian > Fix For: 2.1.x, 2.2.x, 3.0.x, 3.x > > > Schema > {code:sql} > 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)); > {code} > When trying to prepare the following query > {code:sql} > DELETE static_col FROM achilles_embedded.entity_with_static_column WHERE > id=:id_Eq IF static_col=:static_col; > {code} > 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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)