diff options
| author | Alexander Barkov <bar@mariadb.com> | 2018-06-21 12:54:28 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2018-06-21 12:54:28 +0400 |
| commit | bcc2100f9d0bd1a2c21acd0de831e9dd1b8a703e (patch) | |
| tree | a2e91e854ce56a86fca49481a63f424ad47d97ac /mysql-test/main/sql_mode.result | |
| parent | 9dc81f7d387050dd62f2307b15c63c3a3f5ea1b0 (diff) | |
| download | mariadb-git-bcc2100f9d0bd1a2c21acd0de831e9dd1b8a703e.tar.gz | |
MDEV-16471 mysqldump throws "Variable 'sql_mode' can't be set to the value of 'NULL' (1231)"
Diffstat (limited to 'mysql-test/main/sql_mode.result')
| -rw-r--r-- | mysql-test/main/sql_mode.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/main/sql_mode.result b/mysql-test/main/sql_mode.result index 02574c1c545..238bae2efd8 100644 --- a/mysql-test/main/sql_mode.result +++ b/mysql-test/main/sql_mode.result @@ -780,3 +780,27 @@ END; $$ ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'error; END' at line 4 +# +# End of 10.2 tests +# +# +# Start of 10.3 tests +# +# +# MDEV-16471 mysqldump throws "Variable 'sql_mode' can't be set to the value of 'NULL' (1231)" +# +SET sql_mode='ORACLE,EMPTY_STRING_IS_NULL'; +SELECT @@sql_mode; +@@sql_mode +PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ORACLE,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,NO_AUTO_CREATE_USER,EMPTY_STRING_IS_NULL,SIMULTANEOUS_ASSIGNMENT +SELECT '' AS empty; +empty +NULL +SET sql_mode=''; +SELECT @@sql_mode; +@@sql_mode + +SET sql_mode=DEFAULT; +# +# End of 10.3 tests +# |