main.derived_cond_pushdown               [ fail ]

        Test ended at 2023-06-12 00:23:40

CURRENT_TEST: main.derived_cond_pushdown

--- /mnt8t/bld/10.5-asan/mysql-test/main/derived_cond_pushdown.result	2023-06-08 02:00:30.000000000 +0300

+++ /mnt8t/bld/10.5-asan/mysql-test/main/derived_cond_pushdown.reject	2023-06-12 00:23:39.860717505 +0300

@@ -18372,12 +18372,7 @@

 where dt.a=t1.a and t3.a < 3

 )

 from t1 limit 5;

-a	( select concat(t3.a,'=',dt.s)

-from

-(select a, sum(b) as s from t2 group by a) as dt,

-t3

-where dt.a=t1.a and t3.a < 3

-)

+a	Name_exp_2

 1	1=804

 2	1=1056

 3	1=846

@@ -18412,12 +18407,7 @@

 where dt.a=t1.a and t3.a < 3

 )

 from t1 limit 5;

-a	( select concat(t3.a,'=',dt.s)

-from

-(select a, sum(b) as s from t2 group by a) as dt,

-t3

-where dt.a=t1.a and t3.a < 3

-)

+a	Name_exp_2

 1	1=11858

 2	1=11380

 3	1=11588

mysqltest: Result length mismatch