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/suite/innodb/r/innodb-consistent.result | |
| 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/suite/innodb/r/innodb-consistent.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb-consistent.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-consistent.result b/mysql-test/suite/innodb/r/innodb-consistent.result index 9115791b99c..c959dc1adb9 100644 --- a/mysql-test/suite/innodb/r/innodb-consistent.result +++ b/mysql-test/suite/innodb/r/innodb-consistent.result @@ -1,4 +1,7 @@ drop table if exists t1; +connect a,localhost,root,,; +connect b,localhost,root,,; +connection a; set session transaction isolation level read committed; create table t1(a int not null) engine=innodb DEFAULT CHARSET=latin1; create table t2 like t1; @@ -6,21 +9,25 @@ insert into t2 values (1),(2),(3),(4),(5),(6),(7); set autocommit=0; begin; replace into t1 select * from t2; +connection b; set session transaction isolation level read committed; set autocommit=0; delete from t2 where a=5; commit; delete from t2; commit; +connection a; commit; begin; insert into t1 select * from t2; +connection b; set session transaction isolation level read committed; set autocommit=0; delete from t2 where a=5; commit; delete from t2; commit; +connection a; commit; select * from t1; a @@ -33,3 +40,6 @@ a 7 drop table t1; drop table t2; +connection default; +disconnect a; +disconnect b; |