diff options
Diffstat (limited to 'mysql-test/suite/optimizer_unfixed_bugs/r/bug41029.result')
| -rw-r--r-- | mysql-test/suite/optimizer_unfixed_bugs/r/bug41029.result | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/suite/optimizer_unfixed_bugs/r/bug41029.result b/mysql-test/suite/optimizer_unfixed_bugs/r/bug41029.result new file mode 100644 index 00000000..eaad67de --- /dev/null +++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug41029.result @@ -0,0 +1,40 @@ +select @default_binlog_format:=@@global.binlog_format; +@default_binlog_format:=@@global.binlog_format +MIXED +set global binlog_format=row; +connect con1,localhost,root,,; +connect con2,localhost,root,,; +connection con1; +set session debug_dbug="+d,optimizer_innodb_ds_mrr"; +set autocommit=0; +use test; +drop table if exists t1; +Warnings: +Note 1051 Unknown table 'test.t1' +create table t1 (dummy int primary key, a int unique, b int) engine=innodb; +insert into t1 values(1,1,1),(3,3,3),(5,5,5); +commit; +set session transaction isolation level repeatable read; +select @@tx_isolation; +@@tx_isolation +REPEATABLE-READ +start transaction; +select * from t1 where a > 2 for update; +dummy a b +3 3 3 +5 5 5 +connection con2; +use test; +set autocommit=0; +start transaction; +select 1; +1 +1 +insert into t1 values(2,2,2); +ERROR HY000: Lock wait timeout exceeded; try restarting transaction +rollback; +connection con1; +rollback; +drop table t1; +connection default; +set global binlog_format=@default_binlog_format; |