diff options
Diffstat (limited to 'mysql-test/r/flush_block_commit.result')
-rw-r--r-- | mysql-test/r/flush_block_commit.result | 39 |
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; |