summaryrefslogtreecommitdiff
path: root/storage/xtradb/mysql-test/innodb-semi-consistent.result
diff options
context:
space:
mode:
Diffstat (limited to 'storage/xtradb/mysql-test/innodb-semi-consistent.result')
-rw-r--r--storage/xtradb/mysql-test/innodb-semi-consistent.result40
1 files changed, 0 insertions, 40 deletions
diff --git a/storage/xtradb/mysql-test/innodb-semi-consistent.result b/storage/xtradb/mysql-test/innodb-semi-consistent.result
deleted file mode 100644
index 55e3cb5c7b4..00000000000
--- a/storage/xtradb/mysql-test/innodb-semi-consistent.result
+++ /dev/null
@@ -1,40 +0,0 @@
-drop table if exists t1;
-set binlog_format=mixed;
-set session transaction isolation level repeatable read;
-create table t1(a int not null) engine=innodb DEFAULT CHARSET=latin1;
-insert into t1 values (1),(2),(3),(4),(5),(6),(7);
-set autocommit=0;
-select * from t1 where a=3 lock in share mode;
-a
-3
-set binlog_format=mixed;
-set session transaction isolation level repeatable read;
-set autocommit=0;
-update t1 set a=10 where a=5;
-ERROR HY000: Lock wait timeout exceeded; try restarting transaction
-commit;
-set session transaction isolation level read committed;
-update t1 set a=10 where a=5;
-select * from t1 where a=2 for update;
-ERROR HY000: Lock wait timeout exceeded; try restarting transaction
-select * from t1 where a=2 limit 1 for update;
-a
-2
-update t1 set a=11 where a=6;
-update t1 set a=12 where a=2;
-ERROR HY000: Lock wait timeout exceeded; try restarting transaction
-update t1 set a=13 where a=1;
-ERROR HY000: Lock wait timeout exceeded; try restarting transaction
-commit;
-update t1 set a=14 where a=1;
-commit;
-select * from t1;
-a
-14
-2
-3
-4
-10
-11
-7
-drop table t1;