From d943d7f712a48073f0e3936b19557a1762e9f5a8 Mon Sep 17 00:00:00 2001 From: Jerome Brauge Date: Mon, 29 Jan 2018 16:53:39 +0100 Subject: MDEV-13417 UPDATE produces wrong values if an updated column is later used as an update source Standard compatible behavior for UPDATE: all assignments in SET are executed "simultaneously", not left-to-right. And `SET a=b,b=a` will swap the values. --- mysql-test/suite/sys_vars/t/sql_mode_basic.test | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mysql-test/suite/sys_vars/t/sql_mode_basic.test') diff --git a/mysql-test/suite/sys_vars/t/sql_mode_basic.test b/mysql-test/suite/sys_vars/t/sql_mode_basic.test index 1730af50c17..b4841ecd3ff 100644 --- a/mysql-test/suite/sys_vars/t/sql_mode_basic.test +++ b/mysql-test/suite/sys_vars/t/sql_mode_basic.test @@ -307,11 +307,11 @@ SELECT @@global.sql_mode; SET @@global.sql_mode = 500000; SELECT @@global.sql_mode; -SET @@global.sql_mode = 8589934591; +SET @@global.sql_mode = 17179869183; SELECT @@global.sql_mode; --Error ER_WRONG_VALUE_FOR_VAR -SET @@global.sql_mode = 8589934592; +SET @@global.sql_mode = 17179869184; # use of decimal values -- cgit v1.2.1