From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/optimizer_unfixed_bugs/r/bug41029.result | 40 ++++++++++++++++++++++ 1 file changed, 40 insertions(+) create mode 100644 mysql-test/suite/optimizer_unfixed_bugs/r/bug41029.result (limited to 'mysql-test/suite/optimizer_unfixed_bugs/r/bug41029.result') 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; -- cgit v1.2.3