1 # This test should work in embedded server after mysqltest is fixed
2 -- source include/not_embedded.inc
4 # Save the initial number of concurrent sessions
5 --source include/count_sessions.inc
7 --echo Tests of synchronization of stored procedure execution.
9 --source include/have_debug_sync.inc
12 --echo # Bug#48157: crash in Item_field::used_tables
15 CREATE TABLE t1 AS SELECT 1 AS a, 1 AS b;
16 CREATE TABLE t2 AS SELECT 1 AS a, 1 AS b;
22 UPDATE t1 JOIN t2 USING( a, b ) SET t1.b = 1, t2.b = 1;
27 connect (con1,localhost,root,,);
28 connect (con2,localhost,root,,);
31 LOCK TABLES t1 WRITE, t2 WRITE;
34 LET $ID= `select connection_id()`;
35 SET DEBUG_SYNC = 'multi_update_reopen_tables SIGNAL parked WAIT_FOR go';
39 let $wait_condition= SELECT 1 FROM information_schema.processlist WHERE ID = $ID AND
41 --source include/wait_condition.inc
43 SET DEBUG_SYNC = 'now WAIT_FOR parked';
44 CREATE TABLE t1 AS SELECT 1 AS a, 1 AS b;
45 CREATE TABLE t2 AS SELECT 1 AS a, 1 AS b;
46 SET DEBUG_SYNC = 'now SIGNAL go';
55 --echo # Without the DEBUG_SYNC supplied in the same patch as this test in the
56 --echo # code, this test statement will hang.
61 --echo # test for bug#11756013
64 DROP SCHEMA IF EXISTS s1;
67 CREATE PROCEDURE s1.p1() BEGIN END;
69 connect (con3, localhost, root);
70 SET DEBUG_SYNC='before_db_dir_check SIGNAL check_db WAIT_FOR dropped_schema';
74 SET DEBUG_SYNC='now WAIT_FOR check_db';
76 SET DEBUG_SYNC='now SIGNAL dropped_schema';
79 --error ER_BAD_DB_ERROR
84 SET DEBUG_SYNC = 'RESET';
86 # Wait till we reached the initial number of concurrent sessions
87 --source include/wait_until_count_sessions.inc