[ https://issues.apache.org/jira/browse/CASSANDRA-18241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacek Lewandowski updated CASSANDRA-18241: ------------------------------------------ Status: Ready to Commit (was: Review In Progress) > 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 > Fix For: NA > > > {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: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org