maria-developers team mailing list archive
Mailing list archive
Hi, Ian, Russell,
As you know, UPDATE in MariaDB is executed left-to-right, say, in the
UPDATE t1 SET a=b, b=a
both columns will have the same value, old value of `b`. We're now
introducing a new sql_mode to have standard compatible behavior, where
all assignments are executed kind of "simultaneously" (and the statement
above would swap the values).
What could the name for this new sql_mode be?