[Maria-developers] Wording suggestion?
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
'concurrent_eval'/'concurrent_evaluation' ?'? -- Peter -- Webyog On Mon, Jan 29, 2018 at 6:19 PM, Sergei Golubchik <serg@mariadb.org> wrote:
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
or 'concurrent_assign'/'concurrent assignment' -- Peter On Tue, Jan 30, 2018 at 11:35 AM, Peter Laursen <peter_laursen@webyog.com> wrote:
'concurrent_eval'/'concurrent_evaluation'
?'?
-- Peter -- Webyog
On Mon, Jan 29, 2018 at 6:19 PM, Sergei Golubchik <serg@mariadb.org> wrote:
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
participants (2)
-
Peter Laursen
-
Sergei Golubchik