Describe the bug

When using an if statement inside a transaction and assigning to a variable,
the variable value isn't updated outside the transaction.

Without the if, the variable value is successfully updated outside the transaction.

This works ($a is equal to "alice"):

$a = "bob";
begin transaction;
$a = "alice";
commit transaction;
return $a;

This works too (the transaction returns "alice"):

$a = "bob";
begin transaction;
if true {
    $a = "alice";
    return $a;
};
commit transaction;

Steps to reproduce

$a = "bob";
begin transaction;
if true {
   $a = "alice"; 
};
commit transaction;
return $a;

Expected behaviour

$a should be equal to "alice"

SurrealDB version

surreal 2.0.4 for linux on x86_64

Contact Details

No response

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct