Jacek Lewandowski created CASSANDRA-18465:
---------------------------------------------
Summary: Add support for multiple condition branches and results
in Accord transaction
Key: CASSANDRA-18465
URL: https://issues.apache.org/jira/browse/CASSANDRA-18465
Project: Cassandra
Issue Type: New Feature
Components: Accord, CQL/Syntax
Reporter: Jacek Lewandowski
I'd like to propose adding support for multiple branches and result sets for
Accord transactions. It could look like this:
{code:sql}
BEGIN TRANSACTION
LET a = ...
LET b = ...
IF condition THEN
SELECT 'one', a.value
UPDATE ...
ELSE IF condition2 THEN
SELECT 'two', b.value
UPDATE ...
ELSE
SELECT 'three', NULL
END IF
COMMIT TRANSACTION
{code}
The existing syntax would remain valid, when a single SELECT is defined in
which case the conditional SELECTs would not be valid.
SELECTs would be validated to return columns of the same type. They would be
able to return literals as well.
This would be make the result of the transaction more intuitive as the client
would know explicitly if the updates where applied or not.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
