main.derived_split_innodb

CURRENT_TEST: main.derived_split_innodb

--- /buildbot/amd64-ubuntu-2004-icc/build/mysql-test/main/derived_split_innodb.result	2021-03-24 16:56:51.000000000 +0000

+++ /buildbot/amd64-ubuntu-2004-icc/build/mysql-test/main/derived_split_innodb.reject	2021-03-24 20:07:01.754138195 +0000

@@ -48,9 +48,9 @@

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

 1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using where

 1	PRIMARY	<derived2>	ref	key0	key0	5	test.t2.id2	2	

-2	DERIVED	t3	ALL	NULL	NULL	NULL	NULL	1	Using where; Using temporary; Using filesort

-2	DERIVED	t1	eq_ref	PRIMARY,id2	PRIMARY	4	test.t3.i3	1	

-2	DERIVED	t2	ALL	NULL	NULL	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

+2	LATERAL DERIVED	t3	ALL	NULL	NULL	NULL	NULL	1	Using where; Using temporary; Using filesort

+2	LATERAL DERIVED	t1	eq_ref	PRIMARY,id2	PRIMARY	4	test.t3.i3	1	Using where

+2	LATERAL DERIVED	t2	ALL	NULL	NULL	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

 SELECT id3

 FROM (SELECT t3.id3, t2.i2, t1.id2  FROM t3,t1,t2

 WHERE t3.i3=t1.id1 AND t2.id2=t1.id2