diff options
author | Jerome Brauge <j.brauge@qualiac.com> | 2018-01-29 16:53:39 +0100 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2018-02-12 13:14:23 +0100 |
commit | d943d7f712a48073f0e3936b19557a1762e9f5a8 (patch) | |
tree | 4d2ed8128831e8fe131805e4789394c5ed37f117 /mysql-test/suite/sys_vars/t/sql_mode_basic.test | |
parent | 355ee6877beccf27bcd07d845c985fc1a2845aca (diff) | |
download | mariadb-git-d943d7f712a48073f0e3936b19557a1762e9f5a8.tar.gz |
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.
Diffstat (limited to 'mysql-test/suite/sys_vars/t/sql_mode_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/sql_mode_basic.test | 4 |
1 files changed, 2 insertions, 2 deletions
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 |