You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Highstead (JIRA)" <ji...@apache.org> on 2016/09/22 18:33:20 UTC

[jira] [Updated] (CASSANDRA-12691) LWT: Inserting Subset of columns returns all columns

     [ https://issues.apache.org/jira/browse/CASSANDRA-12691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Highstead updated CASSANDRA-12691:
----------------------------------
    Description: 
See: https://github.com/gocql/gocql/issues/792#issuecomment-248983669

When inserting a subset of the table columns with the use of light weight transactions the cassandra result returns a full set of unordered cassandra column values.  

SETUP:
{{
CREATE TABLE IF NOT EXISTS test.inserttest(
    key bigint,
    session_token text,

    foo text, 
    bar text,
PRIMARY KEY(key, event_date, session_token);

INSERT INTO test.inserttest(key, session_token, foo) VALUES (1, 'myToken', 'baz') IF NOT EXISTS;
}}


{{insert into test.inserttest(key, session_token, foo) VALUES (1, 'myToken', 'bez') IF NOT EXISTS;}}

Expected result: Returns False, 1, myToken, baz
Actual result: Returns true and all column values.

  was:
See: https://github.com/gocql/gocql/issues/792#issuecomment-248983669

When inserting a subset of the table columns with the use of light weight transactions the cassandra result returns a full set of unordered cassandra column values.  

SETUP:
```
CREATE TABLE IF NOT EXISTS test.inserttest(
    key bigint,
    session_token text,

    foo text, 
    bar text,
PRIMARY KEY(key, event_date, session_token);

INSERT INTO test.inserttest(key, session_token, foo) VALUES (1, 'myToken', 'baz') IF NOT EXISTS;
```

`insert into test.inserttest(key, session_token, foo) VALUES (1, 'myToken', 'bez') IF NOT EXISTS;`

Expected result: Returns False, 1, myToken, baz
Actual result: Returns true and all column values.


> LWT: Inserting Subset of columns returns all columns
> ----------------------------------------------------
>
>                 Key: CASSANDRA-12691
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12691
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL
>         Environment: 3.x
>            Reporter: Highstead
>            Priority: Minor
>              Labels: transaction, transactions
>
> See: https://github.com/gocql/gocql/issues/792#issuecomment-248983669
> When inserting a subset of the table columns with the use of light weight transactions the cassandra result returns a full set of unordered cassandra column values.  
> SETUP:
> {{
> CREATE TABLE IF NOT EXISTS test.inserttest(
>     key bigint,
>     session_token text,
>     foo text, 
>     bar text,
> PRIMARY KEY(key, event_date, session_token);
> INSERT INTO test.inserttest(key, session_token, foo) VALUES (1, 'myToken', 'baz') IF NOT EXISTS;
> }}
> {{insert into test.inserttest(key, session_token, foo) VALUES (1, 'myToken', 'bez') IF NOT EXISTS;}}
> Expected result: Returns False, 1, myToken, baz
> Actual result: Returns true and all column values.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)