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 /sql/sp.cc | |
| 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 'sql/sp.cc')
| -rw-r--r-- | sql/sp.cc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/sp.cc b/sql/sp.cc index 72257a4a332..5921440057e 100644 --- a/sql/sp.cc +++ b/sql/sp.cc @@ -173,7 +173,7 @@ TABLE_FIELD_TYPE proc_table_fields[MYSQL_PROC_FIELD_COUNT] = "'STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES'," "'ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER'," "'HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'," - "'EMPTY_STRING_IS_NULL')") }, + "'EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT')") }, { NULL, 0 } }, { |