Jacek Lewandowski created CASSANDRA-18241:
---------------------------------------------
Summary: 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
{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]
