innodb.mdev-14846 fails in 11.0

CURRENT_TEST: innodb.mdev-14846

--- /home/buildbot/buildbot/build/mariadb-11.1.4/mysql-test/suite/innodb/r/mdev-14846.result	2023-11-24 15:03:29.000000000 +0000

+++ /home/buildbot/buildbot/build/mariadb-11.1.4/mysql-test/suite/innodb/r/mdev-14846.reject	2023-11-24 17:55:45.075140470 +0000

@@ -38,7 +38,7 @@

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

 1	PRIMARY	alias1	ALL	NULL	NULL	NULL	NULL	#	

 1	PRIMARY	alias2	ALL	NULL	NULL	NULL	NULL	#	Using where

-2	DEPENDENT SUBQUERY	t1	ALL	NULL	NULL	NULL	NULL	#	Using where

+2	MATERIALIZED	t1	ALL	NULL	NULL	NULL	NULL	#	

 UPDATE t3 AS alias1 LEFT JOIN t3 AS alias2 ON ( alias1.f1 <> alias1.f2 ) SET alias1.f3 = 59 WHERE ( EXISTS ( SELECT t1.f3 FROM t1 IGNORE INDEX (f1) WHERE t1.f1 = alias1.f1 ) ) OR alias2.f1 = 'h';

 connect  con2,localhost,root,,test;

 set debug_sync='now WAIT_FOR con2_dml';

@@ -51,8 +51,8 @@

 1	PRIMARY	t1	index	NULL	f1	12	NULL	#	Using index

 1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	#	

 1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	13	func	#	

-2	MATERIALIZED	t3	ALL	NULL	NULL	NULL	NULL	#	

 2	MATERIALIZED	t2	ALL	NULL	NULL	NULL	NULL	#	

+2	MATERIALIZED	t3	ALL	NULL	NULL	NULL	NULL	#	

 UPDATE v4, t1 SET t1.pk = 76 WHERE t1.f2 IN ( SELECT t2.f FROM t2 INNER JOIN t3 );

 connection default;

 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction