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
|