main.derived                             [ fail ]

        Test ended at 2016-08-01 01:28:48

CURRENT_TEST: main.derived

--- /data/bld/10.1/mysql-test/r/derived.result	2016-06-14 18:49:07.000000000 +0300

+++ /data/bld/10.1/mysql-test/r/derived.reject	2016-08-01 01:28:47.987460888 +0300

@@ -621,13 +621,13 @@

 );

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra

 1	PRIMARY	<derived2>	system	NULL	NULL	NULL	NULL	1	100.00	

-1	PRIMARY	<subquery4>	eq_ref	distinct_key	distinct_key	4	sq.f2	1	100.00	

+1	PRIMARY	<subquery4>	eq_ref	distinct_key	distinct_key	4	const	1	100.00	

 1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	2	100.00	Using where; FirstMatch(<subquery4>); Using join buffer (flat, BNL join)

 4	MATERIALIZED	t2	ALL	NULL	NULL	NULL	NULL	2	100.00	

 2	DERIVED	t1	system	NULL	NULL	NULL	NULL	1	100.00	

 Warnings:

 Note	1276	Field or reference 'sq.f2' of SELECT #3 was resolved in SELECT #1

-Note	1003	select 6 AS `f1` from  <materialize> (select `test`.`t2`.`f3` from `test`.`t2` having (`test`.`t2`.`f3` >= 8)) semi join (`test`.`t2`) where ((`test`.`t2`.`f3` = 6) and (9 = `<subquery4>`.`f3`))

+Note	1003	select 6 AS `f1` from  <materialize> (select `test`.`t2`.`f3` from `test`.`t2` having (`test`.`t2`.`f3` >= 8)) semi join (`test`.`t2`) where ((`test`.`t2`.`f3` = 6) and (`<subquery4>`.`f3` = 9))

 DROP TABLE t2,t1;

 #

 # MDEV-9462: Out of memory using explain on 2 empty tables 

mysqltest: Result content mismatch