summaryrefslogtreecommitdiff
path: root/mysql-test/r/flush_block_commit.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/flush_block_commit.result')
-rw-r--r--mysql-test/r/flush_block_commit.result39
1 files changed, 21 insertions, 18 deletions
diff --git a/mysql-test/r/flush_block_commit.result b/mysql-test/r/flush_block_commit.result
index 7062d05c2d7..e9684e5aa46 100644
--- a/mysql-test/r/flush_block_commit.result
+++ b/mysql-test/r/flush_block_commit.result
@@ -1,50 +1,50 @@
# Save the initial number of concurrent sessions
-# Establish connection con1 (user=root)
-# Establish connection con2 (user=root)
-# Establish connection con3 (user=root)
-# Switch to connection con1
+connect con1,localhost,root,,;
+connect con2,localhost,root,,;
+connect con3,localhost,root,,;
+connection con1;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a INT) ENGINE=innodb;
BEGIN;
INSERT INTO t1 VALUES(1);
-# Switch to connection con2
+connection con2;
FLUSH TABLES WITH READ LOCK;
-# Switch to connection con1
+connection con1;
# Sending:
COMMIT;
-# Switch to connection con2
+connection con2;
# Wait until COMMIT gets blocked.
# Verify that 'con1' was blocked and data did not move.
SELECT * FROM t1;
a
UNLOCK TABLES;
-# Switch to connection con1
+connection con1;
# Reaping COMMIT
-# Switch to connection con1
+connection con1;
BEGIN;
SELECT * FROM t1 FOR UPDATE;
a
1
-# Switch to connection con2
+connection con2;
BEGIN;
SELECT * FROM t1 FOR UPDATE;
-# Switch to connection con3
+connection con3;
FLUSH TABLES WITH READ LOCK;
-# Switch to connection con1
+connection con1;
COMMIT;
-# Switch to connection con2
+connection con2;
a
1
COMMIT;
-# Switch to connection con3
+connection con3;
UNLOCK TABLES;
-# Switch to connection con2
+connection con2;
COMMIT;
-# Switch to connection con1
+connection con1;
BEGIN;
INSERT INTO t1 VALUES(10);
FLUSH TABLES WITH READ LOCK;
-# Switch to connection con2
+connection con2;
FLUSH TABLES WITH READ LOCK;
UNLOCK TABLES;
BEGIN;
@@ -57,7 +57,10 @@ Database Create Database
test CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */
COMMIT;
# Cleanup
-# Switch to connection default and close connections con1, con2, con3
+connection default;
+disconnect con1;
+disconnect con2;
+disconnect con3;
# We commit open transactions when we disconnect: only then we can
# drop the table.
DROP TABLE t1;