[
https://issues.apache.org/jira/browse/CASSANDRA-18241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacek Lewandowski reassigned CASSANDRA-18241:
---------------------------------------------
Assignee: Jacek Lewandowski
> Invalid result when a non existent row is assigned to a variable
> ----------------------------------------------------------------
>
> Key: CASSANDRA-18241
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18241
> Project: Cassandra
> Issue Type: Bug
> Components: Accord
> Reporter: Jacek Lewandowski
> Assignee: Jacek Lewandowski
> Priority: Normal
>
> {noformat}
> cqlsh:ks> CREATE TABLE tbl3 (k INT, c INT, v INT, PRIMARY KEY (k, c));
> cqlsh:ks>
> BEGIN TRANSACTION
> LET row = (SELECT * FROM tbl3 WHERE k=1 LIMIT 1);
> SELECT row.k, row.c, row.v;
> IF row.c > 10 THEN
> INSERT INTO ks.tbl3 (k, c, v) VALUES (1, 10, 110);
> END IF
> COMMIT TRANSACTION;
> row.k | row.c | row.v
> -------+-------+-------
> 1 | null | null
> cqlsh:ks> SELECT * FROM tbl3;
> k | c | v
> ---+---+---
> (0 rows)
> {noformat}
> as discussed on Slack, the transaction should return:
> {noformat}
> row.k | row.c | row.v
> -------+-------+-------
> null | null | null
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
