diff options
| author | Vladislav Vaintroub <wlad@mariadb.com> | 2016-04-09 17:03:48 +0200 |
|---|---|---|
| committer | Vladislav Vaintroub <wlad@mariadb.com> | 2016-04-09 17:03:48 +0200 |
| commit | cd776fedba3e2902bc25ee206d6e6266e7eb9411 (patch) | |
| tree | 95bf82d0e0522c6af708cd28639c82e004b5a264 /mysql-test/t/consistent_snapshot.test | |
| parent | f884d233e6a5f68bab846a7bdbd041fc4415ad77 (diff) | |
| parent | d516a2ae0cbd09d3b5b1667ec62b421330ab9902 (diff) | |
| download | mariadb-git-10.2-connector-c-integ.tar.gz | |
Merge branch '10.2' into 10.2-connector-c-integ10.2-connector-c-integ
Diffstat (limited to 'mysql-test/t/consistent_snapshot.test')
| -rw-r--r-- | mysql-test/t/consistent_snapshot.test | 10 |
1 files changed, 0 insertions, 10 deletions
diff --git a/mysql-test/t/consistent_snapshot.test b/mysql-test/t/consistent_snapshot.test index fb1f3bc007c..a481e757bed 100644 --- a/mysql-test/t/consistent_snapshot.test +++ b/mysql-test/t/consistent_snapshot.test @@ -7,25 +7,20 @@ DROP TABLE IF EXISTS t1; --enable_warnings ---echo # Establish connection con1 (user=root) connect (con1,localhost,root,,); ---echo # Establish connection con2 (user=root) connect (con2,localhost,root,,); --echo ### Test 1: --echo ### - While a consistent snapshot transaction is executed, --echo ### no external inserts should be visible to the transaction. ---echo # Switch to connection con1 connection con1; CREATE TABLE t1 (a INT) ENGINE=innodb; START TRANSACTION WITH CONSISTENT SNAPSHOT; ---echo # Switch to connection con2 connection con2; INSERT INTO t1 VALUES(1); ---echo # Switch to connection con1 connection con1; SELECT * FROM t1; # if consistent snapshot was set as expected, we # should see nothing. @@ -38,11 +33,9 @@ COMMIT; DELETE FROM t1; START TRANSACTION; # Now we omit WITH CONSISTENT SNAPSHOT ---echo # Switch to connection con2 connection con2; INSERT INTO t1 VALUES(1); ---echo # Switch to connection con1 connection con1; SELECT * FROM t1; # if consistent snapshot was not set, as expected, we # should see 1. @@ -56,17 +49,14 @@ START TRANSACTION WITH CONSISTENT SNAPSHOT; DELETE FROM t1; COMMIT WORK AND CHAIN; ---echo # Switch to connection con2 connection con2; INSERT INTO t1 VALUES(1); ---echo # Switch to connection con1 connection con1; SELECT * FROM t1; # if consistent snapshot was not set, as expected, we # should see 1. COMMIT; ---echo # Switch to connection default + close connections con1 and con2 connection default; disconnect con1; disconnect con2; |