diff options
Diffstat (limited to 'mysql-test/r/consistent_snapshot.result')
| -rw-r--r-- | mysql-test/r/consistent_snapshot.result | 22 |
1 files changed, 12 insertions, 10 deletions
diff --git a/mysql-test/r/consistent_snapshot.result b/mysql-test/r/consistent_snapshot.result index 3a0227b1a1a..b978f1dd9d2 100644 --- a/mysql-test/r/consistent_snapshot.result +++ b/mysql-test/r/consistent_snapshot.result @@ -1,15 +1,15 @@ DROP TABLE IF EXISTS t1; -# Establish connection con1 (user=root) -# Establish connection con2 (user=root) +connect con1,localhost,root,,; +connect con2,localhost,root,,; ### Test 1: ### - While a consistent snapshot transaction is executed, ### no external inserts should be visible to the transaction. -# Switch to connection con1 +connection con1; CREATE TABLE t1 (a INT) ENGINE=innodb; START TRANSACTION WITH CONSISTENT SNAPSHOT; -# Switch to connection con2 +connection con2; INSERT INTO t1 VALUES(1); -# Switch to connection con1 +connection con1; SELECT * FROM t1; a COMMIT; @@ -18,9 +18,9 @@ COMMIT; ### committed inserts should be visible to the transaction. DELETE FROM t1; START TRANSACTION; -# Switch to connection con2 +connection con2; INSERT INTO t1 VALUES(1); -# Switch to connection con1 +connection con1; SELECT * FROM t1; a 1 @@ -31,12 +31,14 @@ COMMIT; START TRANSACTION WITH CONSISTENT SNAPSHOT; DELETE FROM t1; COMMIT WORK AND CHAIN; -# Switch to connection con2 +connection con2; INSERT INTO t1 VALUES(1); -# Switch to connection con1 +connection con1; SELECT * FROM t1; a 1 COMMIT; -# Switch to connection default + close connections con1 and con2 +connection default; +disconnect con1; +disconnect con2; DROP TABLE t1; |