summaryrefslogtreecommitdiff
path: root/mysql-test/suite/binlog/t/binlog_stm_row.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/binlog/t/binlog_stm_row.test')
-rw-r--r--mysql-test/suite/binlog/t/binlog_stm_row.test13
1 files changed, 0 insertions, 13 deletions
diff --git a/mysql-test/suite/binlog/t/binlog_stm_row.test b/mysql-test/suite/binlog/t/binlog_stm_row.test
index 87758d57725..bade737c114 100644
--- a/mysql-test/suite/binlog/t/binlog_stm_row.test
+++ b/mysql-test/suite/binlog/t/binlog_stm_row.test
@@ -42,14 +42,11 @@ INSERT INTO t2 VALUES(2);
--echo #
--connection con1
---echo # con1
SELECT GET_LOCK('Bug#34306', 120);
--connection con2
---echo # con2
PREPARE stmt FROM "INSERT INTO t1 SELECT * FROM t2 WHERE GET_LOCK('Bug#34306', 120)";
--send EXECUTE stmt;
--connection default
---echo # default
let $wait_condition=
SELECT COUNT(*) = 1 FROM information_schema.processlist WHERE
state = "User lock" AND
@@ -57,18 +54,15 @@ let $wait_condition=
--source include/wait_condition.inc
--send INSERT INTO t2 VALUES (3);
--connection con1
---echo # con1
let $wait_condition=
SELECT COUNT(*) = 1 FROM information_schema.processlist WHERE
state = "Waiting for table level lock" and info = "INSERT INTO t2 VALUES (3)";
--source include/wait_condition.inc
SELECT RELEASE_LOCK('Bug#34306');
--connection con2
---echo # con2
--reap
SELECT RELEASE_LOCK('Bug#34306');
--connection default
---echo # default
--reap
--echo #
@@ -77,33 +71,26 @@ SELECT RELEASE_LOCK('Bug#34306');
--echo #
--connection con2
---echo # con2
SET SESSION BINLOG_FORMAT = ROW;
--connection con1
---echo # con1
SELECT GET_LOCK('Bug#34306', 120);
--connection con2
---echo # con2
--send EXECUTE stmt;
--connection default
---echo # default
let $wait_condition=
SELECT COUNT(*) = 1 FROM information_schema.processlist WHERE
state = "User lock" AND
info = "INSERT INTO t1 SELECT * FROM t2 WHERE GET_LOCK('Bug#34306', 120)";
--source include/wait_condition.inc
--connection con1
---echo # con1
INSERT INTO t2 VALUES (4);
SELECT RELEASE_LOCK('Bug#34306');
--connection con2
---echo # con2
--reap
--disconnect con1
--disconnect con2
--connection default
---echo # default
--echo # Show binlog events
source include/show_binlog_events.inc;