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/commit.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/commit.test')
| -rw-r--r-- | mysql-test/t/commit.test | 32 |
1 files changed, 0 insertions, 32 deletions
diff --git a/mysql-test/t/commit.test b/mysql-test/t/commit.test index c2051358073..762397dfa23 100644 --- a/mysql-test/t/commit.test +++ b/mysql-test/t/commit.test @@ -15,7 +15,6 @@ connect (con1,localhost,root,,); # provided # init ---echo connection default; connection default; SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; @@ -63,13 +62,11 @@ START TRANSACTION; SELECT * FROM t1; SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; ---echo connection con1 connection con1; START TRANSACTION; INSERT INTO t1 VALUES (1000); COMMIT; ---echo connection default connection default; --echo We should not be able to read the '1000' SELECT * FROM t1; @@ -99,29 +96,24 @@ SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; # transaction will have the same tran. iso. level # as the first. # ---echo connection default connection default; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; START TRANSACTION; ---echo connection con1 connection con1; START TRANSACTION; INSERT INTO t1 VALUES (1001); COMMIT; ---echo connection default connection default; SELECT COUNT(*) FROM t1 WHERE s1 = 1001; --echo Should be 1 COMMIT AND CHAIN; ---echo connection con1 connection con1; INSERT INTO t1 VALUES (1002); COMMIT; ---echo connection default connection default; SELECT COUNT(*) FROM t1 WHERE s1 = 1002; --echo Should be 1 @@ -133,29 +125,24 @@ COMMIT; # # Verify isolation level with ROLLBACK AND CHAIN # ---echo connection default connection default; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; START TRANSACTION; ---echo connection con1 connection con1; START TRANSACTION; INSERT INTO t1 VALUES (1001); COMMIT; ---echo connection default connection default; SELECT COUNT(*) FROM t1 WHERE s1 = 1001; --echo Should be 1 ROLLBACK AND CHAIN; ---echo connection con1 connection con1; INSERT INTO t1 VALUES (1002); COMMIT; ---echo connection default connection default; SELECT COUNT(*) FROM t1 WHERE s1 = 1002; --echo Should be 1 @@ -176,40 +163,33 @@ COMMIT; # SET @@completion_type=1; ---echo connection default connection default; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; START TRANSACTION; ---echo connection con1 connection con1; START TRANSACTION; INSERT INTO t1 VALUES (1001); COMMIT; ---echo connection default connection default; SELECT * FROM t1 WHERE s1 >= 1000; --echo Should see 1001 COMMIT AND NO CHAIN; --echo default transaction is now in REPEATABLE READ ---echo connection con1 connection con1; INSERT INTO t1 VALUES (1002); COMMIT; ---echo connection default connection default; SELECT * FROM t1 WHERE s1 >= 1000; --echo Should see 1001 and 1002 ---echo connection con1 connection con1; INSERT INTO t1 VALUES (1003); COMMIT; ---echo connection default connection default; SELECT * FROM t1 WHERE s1 >= 1000; --echo Should see 1001 and 1002, but NOT 1003 @@ -225,42 +205,35 @@ COMMIT; # Verify that ROLLBACK AND NO CHAIN overrides the value # of @@completion_type # ---echo connection default connection default; SET @@completion_type=1; COMMIT AND NO CHAIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; START TRANSACTION; ---echo connection con1 connection con1; START TRANSACTION; INSERT INTO t1 VALUES (1001); COMMIT; ---echo connection default connection default; SELECT * FROM t1 WHERE s1 >= 1000; --echo Should see 1001 ROLLBACK AND NO CHAIN; --echo default transaction is now in REPEATABLE READ ---echo connection con1 connection con1; INSERT INTO t1 VALUES (1002); COMMIT; ---echo connection default connection default; SELECT * FROM t1 WHERE s1 >= 1000; --echo Should see 1001 and 1002 ---echo connection con1 connection con1; INSERT INTO t1 VALUES (1003); COMMIT; ---echo connection default connection default; SELECT * FROM t1 WHERE s1 >= 1000; --echo Should see 1001 and 1002, but NOT 1003 @@ -281,7 +254,6 @@ COMMIT; # SET TRANSACTION. (Note that this is _not_ # in accordance with ISO 9075.) # ---echo connection default connection default; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; @@ -289,12 +261,10 @@ SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; START TRANSACTION; SELECT * FROM t1; ---echo connection con1 connection con1; INSERT INTO t1 VALUES (1000); COMMIT; ---echo connection default connection default; SELECT * FROM t1; --echo Should get same result as above (i.e should not read '1000') @@ -320,12 +290,10 @@ INSERT INTO t1 VALUES (1000); SELECT * FROM t1; --echo Should read '1000' ---echo connection con1 connection con1; INSERT INTO t1 VALUES (1001); COMMIT; ---echo connection default connection default; SELECT * FROM t1; --echo Should only read the '1000' as this transaction is now in REP READ |