summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl_sp.test
diff options
context:
space:
mode:
authorunknown <thek@kpdesk.mysql.com>2006-11-28 17:34:03 +0100
committerunknown <thek@kpdesk.mysql.com>2006-11-28 17:34:03 +0100
commitb25659d9d949bb921572dc55b8936b627ac35fe4 (patch)
treef4ac0a82bf3b7ac1e782b54f5aec668f5b46cc79 /mysql-test/t/rpl_sp.test
parentd56ab27a5ff348619c9eef7ce3d350c83081f43f (diff)
parent9a87702b033bc9bab337e716a52532c4e4599057 (diff)
downloadmariadb-git-b25659d9d949bb921572dc55b8936b627ac35fe4.tar.gz
Merge kpdesk.mysql.com:/home/thek/dev/bug22043/my50-bug22043
into kpdesk.mysql.com:/home/thek/dev/bug22043/my51-bug22043 sql/sp.cc: Auto merged sql/sql_parse.cc: Auto merged mysql-test/r/rpl_sp.result: - Merged; moved comments to end of file mysql-test/t/rpl_sp.test: - Merged; added comments to end of file
Diffstat (limited to 'mysql-test/t/rpl_sp.test')
-rw-r--r--mysql-test/t/rpl_sp.test21
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_sp.test b/mysql-test/t/rpl_sp.test
index 4ee3338ad01..0e0de7cf2e7 100644
--- a/mysql-test/t/rpl_sp.test
+++ b/mysql-test/t/rpl_sp.test
@@ -526,6 +526,27 @@ sync_slave_with_master;
set global log_bin_trust_function_creators=0;
connection master;
set global log_bin_trust_function_creators=0;
+#
+# Bug22043: MySQL don't add "USE <DATABASE>" before "DROP PROCEDURE IF EXISTS"
+#
+connection master;
+--disable_warnings
+drop database if exists mysqltest;
+drop database if exists mysqltest2;
+--enable_warnings
+create database mysqltest;
+create database mysqltest2;
+use mysqltest2;
+create table t ( t integer );
+create procedure mysqltest.test() begin end;
+insert into t values ( 1 );
+show binlog events in 'master-bin.000001' from 8186;
+--error ER_WRONG_DB_NAME
+create procedure `\\`.test() begin end;
+# Clean up
+drop database mysqltest;
+drop database mysqltest2;
--echo End of 5.0 tests
--echo End of 5.1 tests
+