[jira] [Commented] (CASSANDRA-10532) Allow LWT operation on static column with only partition keys

["Carl Yeksigian (JIRA)" <ji...@apache.org>]

    [ 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)