diff options
author | gluh@eagle.intranet.mysql.r18.ru <> | 2005-06-09 14:39:29 +0500 |
---|---|---|
committer | gluh@eagle.intranet.mysql.r18.ru <> | 2005-06-09 14:39:29 +0500 |
commit | 8574ed6fc657048d3ef7c05570d6bf8bf35d7553 (patch) | |
tree | 417c40506a0a56513b22ab4e2f679b8127e96fdf /mysql-test | |
parent | 90ddbe87d65d82994b0b9179117152708bfc7f42 (diff) | |
download | mariadb-git-8574ed6fc657048d3ef7c05570d6bf8bf35d7553.tar.gz |
Fix for bug#10732: Set SQL_MODE to NULL gives garbled error message
generate proper error message if we use SET ... = NULL for 'set'
variables
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/sql_mode.result | 2 | ||||
-rw-r--r-- | mysql-test/t/sql_mode.test | 5 |
2 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/sql_mode.result b/mysql-test/r/sql_mode.result index c18be2df403..652913d1fdb 100644 --- a/mysql-test/r/sql_mode.result +++ b/mysql-test/r/sql_mode.result @@ -138,3 +138,5 @@ t1 CREATE TABLE `t1` ( `min_num` decimal(7,6) default '0.000001' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1 ; +set @@SQL_MODE=NULL; +ERROR 42000: Variable 'sql_mode' can't be set to the value of 'NULL' diff --git a/mysql-test/t/sql_mode.test b/mysql-test/t/sql_mode.test index f841d36e837..985c0853bd2 100644 --- a/mysql-test/t/sql_mode.test +++ b/mysql-test/t/sql_mode.test @@ -80,3 +80,8 @@ create table t1 ( min_num dec(6,6) default .000001); show create table t1; drop table t1 ; +# +# Bug #10732: Set SQL_MODE to NULL gives garbled error message +# +--error 1231 +set @@SQL_MODE=NULL; |