diff options
| author | Dmitry Shulga <Dmitry.Shulga@oracle.com> | 2011-06-24 00:02:58 +0700 |
|---|---|---|
| committer | Dmitry Shulga <Dmitry.Shulga@oracle.com> | 2011-06-24 00:02:58 +0700 |
| commit | e42a24e58c45c02d5c7561efde094769fdd57164 (patch) | |
| tree | f8c73e20154892449146f9b034ae2b7c5210d353 /mysql-test/t/sp_sync.test | |
| parent | 7545f86670f6599dacaf934eb2932338529169b9 (diff) | |
| parent | bc7af1757939f1ec3c389da73176c7c68a8bafd5 (diff) | |
| download | mariadb-git-e42a24e58c45c02d5c7561efde094769fdd57164.tar.gz | |
Manual merge of patch for bug#11756013 from mysql-5.1 tree.
Diffstat (limited to 'mysql-test/t/sp_sync.test')
| -rw-r--r-- | mysql-test/t/sp_sync.test | 29 |
1 files changed, 27 insertions, 2 deletions
diff --git a/mysql-test/t/sp_sync.test b/mysql-test/t/sp_sync.test index 368a09eac8c..589832bb570 100644 --- a/mysql-test/t/sp_sync.test +++ b/mysql-test/t/sp_sync.test @@ -1,7 +1,7 @@ # This test should work in embedded server after mysqltest is fixed -- source include/not_embedded.inc ---echo Tests of syncronization of stored procedure execution. +--echo Tests of synchronization of stored procedure execution. --source include/have_debug_sync.inc @@ -149,9 +149,34 @@ disconnect con2; DROP PROCEDURE p1; DROP FUNCTION f1; DROP TABLES t0, t1; -SET DEBUG_SYNC= 'RESET'; +--echo # +--echo # test for bug#11756013 +--echo # +--disable_warnings +DROP SCHEMA IF EXISTS s1; +--enable_warnings +CREATE SCHEMA s1; +CREATE PROCEDURE s1.p1() BEGIN END; + +connect (con3, localhost, root); +SET DEBUG_SYNC='before_db_dir_check SIGNAL check_db WAIT_FOR dropped_schema'; +--send CALL s1.p1 + +connection default; +SET DEBUG_SYNC='now WAIT_FOR check_db'; +DROP SCHEMA s1; +SET DEBUG_SYNC='now SIGNAL dropped_schema'; + +connection con3; +--error ER_BAD_DB_ERROR +--reap +connection default; +disconnect con3; + +SET DEBUG_SYNC = 'RESET'; + # Check that all connections opened by test cases in this file are really # gone so execution of other tests won't be affected by their presence. --source include/wait_until_count_sessions.inc |