maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Ian, Russell,

As you know, UPDATE in MariaDB is executed left-to-right, say, in the
case of

  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?

Regards,
Sergei