Debian Codegraph @

mysql-test/suite/optimizer_unfixed_bugs/r/bug41029.result

raw
1 select @default_binlog_format:=@@global.binlog_format;
2 @default_binlog_format:=@@global.binlog_format
3 MIXED
4 set global binlog_format=row;
5 connect con1,localhost,root,,;
6 connect con2,localhost,root,,;
7 connection con1;
8 set session debug_dbug="+d,optimizer_innodb_ds_mrr";
9 set autocommit=0;
10 use test;
11 drop table if exists t1;
12 Warnings:
13 Note 1051 Unknown table 'test.t1'
14 create table t1 (dummy int primary key, a int unique, b int) engine=innodb;
15 insert into t1 values(1,1,1),(3,3,3),(5,5,5);
16 commit;
17 set session transaction isolation level repeatable read;
18 select @@transaction_isolation;
19 @@transaction_isolation
20 REPEATABLE-READ
21 start transaction;
22 select * from t1 where a > 2 for update;
23 dummy a b
24 3 3 3
25 5 5 5
26 connection con2;
27 use test;
28 set autocommit=0;
29 start transaction;
30 select 1;
31 1
32 1
33 insert into t1 values(2,2,2);
34 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
35 rollback;
36 connection con1;
37 rollback;
38 drop table t1;
39 connection default;
40 set global binlog_format=@default_binlog_format;