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
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp