diff options
| -rw-r--r-- | mysql-test/t/isolation.test | 25 |
1 files changed, 2 insertions, 23 deletions
diff --git a/mysql-test/t/isolation.test b/mysql-test/t/isolation.test index 34d397c4125..d9750ecb351 100644 --- a/mysql-test/t/isolation.test +++ b/mysql-test/t/isolation.test @@ -1,13 +1,12 @@ +source include/have_gemini.inc source include/master-slave.inc; connection master; -use test; drop table if exists t1; create table t1 (f1 char(20) not null) type = gemini; set autocommit=0; insert into t1 (f1) values ("test1"), ("bar"); connection master1; -use test; !$1030 select * from t1; connection master; commit; @@ -16,7 +15,6 @@ drop table if exists t1; create table t1 (f1 char(20) not null) type = gemini; insert into t1 (f1) values ("test2"), ("bar"); connection master1; -use test; set transaction isolation level serializable; !$-1217 select * from t1; connection master; @@ -26,7 +24,6 @@ drop table if exists t1; create table t1 (f1 char(20) not null) type = gemini; insert into t1 (f1) values ("test3"), ("bar"); connection master1; -use test; set transaction isolation level read uncommitted; select * from t1; connection master; @@ -35,7 +32,6 @@ commit; drop table if exists t1; create table t1 (f1 char(20) not null) type = gemini; connection master1; -use test; set transaction isolation level read committed; select * from t1; connection master; @@ -45,7 +41,6 @@ drop table if exists t1; create table t1 (f1 char(20) not null) type = gemini; insert into t1 (f1) values ("test4"), ("bar"); connection master1; -use test; set transaction isolation level repeatable read; select * from t1; connection master; @@ -56,7 +51,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level serializable; insert into t1 (f1) values ("test5"), ("bar"); connection master1; -use test; set transaction isolation level serializable; select * from t1; connection master; @@ -67,7 +61,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level serializable; insert into t1 (f1) values ("test6"), ("bar"); connection master1; -use test; set transaction isolation level read uncommitted; select * from t1; connection master; @@ -78,7 +71,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level serializable; insert into t1 (f1) values ("test7"), ("bar"); connection master1; -use test; set transaction isolation level read committed; select * from t1; connection master; @@ -89,7 +81,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level serializable; insert into t1 (f1) values ("test8"), ("bar"); connection master1; -use test; set transaction isolation level repeatable read; select * from t1; connection master; @@ -100,7 +91,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level read uncommitted; insert into t1 (f1) values ("test9"), ("bar"); connection master1; -use test; set transaction isolation level serializable; select * from t1; connection master; @@ -111,7 +101,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level read uncommitted; insert into t1 (f1) values ("test10"), ("bar"); connection master1; -use test; set transaction isolation level read uncommitted; select * from t1; connection master; @@ -122,7 +111,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level read uncommitted; insert into t1 (f1) values ("test11"), ("bar"); connection master1; -use test; set transaction isolation level read committed; select * from t1; connection master; @@ -133,7 +121,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level read uncommitted; insert into t1 (f1) values ("test12"), ("bar"); connection master1; -use test; set transaction isolation level repeatable read; select * from t1; connection master; @@ -144,7 +131,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level read committed; insert into t1 (f1) values ("test13"), ("bar"); connection master1; -use test; set transaction isolation level serializable; select * from t1; connection master; @@ -155,7 +141,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level read committed; insert into t1 (f1) values ("test14"), ("bar"); connection master1; -use test; set transaction isolation level read uncommitted; select * from t1; connection master; @@ -166,7 +151,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level read committed; insert into t1 (f1) values ("test15"), ("bar"); connection master1; -use test; set transaction isolation level read committed; select * from t1; connection master; @@ -177,7 +161,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level read committed; insert into t1 (f1) values ("test16"), ("bar"); connection master1; -use test; set transaction isolation level repeatable read; select * from t1; connection master; @@ -188,7 +171,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level repeatable read; insert into t1 (f1) values ("test17"), ("bar"); connection master1; -use test; set transaction isolation level serializable; select * from t1; connection master; @@ -199,7 +181,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level repeatable read; insert into t1 (f1) values ("test18"), ("bar"); connection master1; -use test; set transaction isolation level read uncommitted; select * from t1; connection master; @@ -210,7 +191,6 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level repeatable read; insert into t1 (f1) values ("test19"), ("bar"); connection master1; -use test; set transaction isolation level read committed; select * from t1; connection master; @@ -221,9 +201,8 @@ create table t1 (f1 char(20) not null) type = gemini; set transaction isolation level repeatable read; insert into t1 (f1) values ("test20"), ("bar"); connection master1; -use test; set transaction isolation level repeatable read; select * from t1; connection master; commit; - +drop table t1; |