summaryrefslogtreecommitdiff
path: root/mysql-test/t/sql_mode.test
diff options
context:
space:
mode:
authorunknown <guilhem@mysql.com>2006-02-18 19:07:32 +0100
committerunknown <guilhem@mysql.com>2006-02-18 19:07:32 +0100
commit2db2907e359fc1b527275e2d963176608e4a4216 (patch)
tree752fc742b26a858079ca0b5b18f032c03f5a605b /mysql-test/t/sql_mode.test
parent6b4136a7cdc9bf5f4f80b5b3c695934f4573cca7 (diff)
parent10ce919bda7379377cf36e352527449f5330ad45 (diff)
downloadmariadb-git-2db2907e359fc1b527275e2d963176608e4a4216.tar.gz
Merge mysql.com:/home/mysql_src/mysql-5.0
into mysql.com:/home/mysql_src/mysql-5.1-new; will fix manually sp_head.cc and mysqld.cc later soon. mysql-test/extra/binlog_tests/mix_innodb_myisam_binlog.test: Auto merged mysql-test/r/binlog_stm_mix_innodb_myisam.result: Auto merged mysql-test/r/rpl_sp.result: Auto merged mysql-test/r/sql_mode.result: Auto merged mysql-test/t/rpl_sp-slave.opt: Auto merged mysql-test/t/rpl_sp.test: Auto merged mysql-test/t/sql_mode.test: Auto merged sql/set_var.cc: Auto merged sql/log.cc: auto merged sql/mysqld.cc: will fix manually sql/sp_head.cc: will fix manually
Diffstat (limited to 'mysql-test/t/sql_mode.test')
-rw-r--r--mysql-test/t/sql_mode.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/sql_mode.test b/mysql-test/t/sql_mode.test
index 08a03df3274..b4225ef8c4e 100644
--- a/mysql-test/t/sql_mode.test
+++ b/mysql-test/t/sql_mode.test
@@ -255,4 +255,13 @@ create view v2 as select a from t2 where a in (select a from v1);
drop view v2, v1;
drop table t1, t2;
+select @@sql_mode;
+set sql_mode=2097152;
+select @@sql_mode;
+set sql_mode=16384+(65536*4);
+select @@sql_mode;
+--error 1231
+set sql_mode=2147483648; # that mode does not exist
+select @@sql_mode;
+
SET @@SQL_MODE=@OLD_SQL_MODE;