diff options
Diffstat (limited to 'mysql-test/r/subselect_mat_cost_bugs.result')
| -rw-r--r-- | mysql-test/r/subselect_mat_cost_bugs.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/subselect_mat_cost_bugs.result b/mysql-test/r/subselect_mat_cost_bugs.result index 125da8da517..d179a57bcac 100644 --- a/mysql-test/r/subselect_mat_cost_bugs.result +++ b/mysql-test/r/subselect_mat_cost_bugs.result @@ -96,8 +96,8 @@ WHERE t1.pk) ; id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 9 100.00 Using where 2 DEPENDENT SUBQUERY t1b ALL NULL NULL NULL NULL 9 100.00 -2 DEPENDENT SUBQUERY t1a ref c2 c2 5 test.t1b.pk 1 100.00 Using where -2 DEPENDENT SUBQUERY t2 index c3 c3 9 NULL 2 100.00 Using where; Using index; Using join buffer (flat, BNL join) +2 DEPENDENT SUBQUERY t1a hash_ALL c2 #hash#c2 5 test.t1b.pk 9 11.11 Using where; Using join buffer (flat, BNLH join) +2 DEPENDENT SUBQUERY t2 index c3 c3 9 NULL 2 100.00 Using where; Using index; Using join buffer (incremental, BNL join) Warnings: Note 1276 Field or reference 'test.t1.pk' of SELECT #2 was resolved in SELECT #1 Note 1003 /* select#1 */ select `test`.`t1`.`pk` AS `pk` from `test`.`t1` where <expr_cache><`test`.`t1`.`c1`,`test`.`t1`.`pk`>(<in_optimizer>(`test`.`t1`.`c1`,<exists>(/* select#2 */ select `test`.`t1a`.`c1` from `test`.`t1b` join `test`.`t2` left join `test`.`t1a` on(`test`.`t1a`.`c2` = `test`.`t1b`.`pk` and 2) where `test`.`t1`.`pk` <> 0 and <cache>(`test`.`t1`.`c1`) = `test`.`t1a`.`c1` and `test`.`t2`.`c3` = `test`.`t1b`.`c4`))) @@ -194,8 +194,8 @@ WHERE t1.f1 AND alias2.f10 ) ORDER BY field1 ; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 Using where; Using filesort -1 PRIMARY alias1 eq_ref PRIMARY PRIMARY 4 alias2.f3 1 Using index +1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 Using where; Using temporary; Using filesort +1 PRIMARY alias1 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 alias2.f3 2 Using index; Using join buffer (flat, BNLH join) 3 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 3 DEPENDENT SUBQUERY t1 index PRIMARY PRIMARY 4 NULL 2 Using where; Using index; Using join buffer (flat, BNL join) 2 DERIVED t2 ALL NULL NULL NULL NULL 2 @@ -264,7 +264,7 @@ WHERE alias1.f11 OR alias1.f3 = 50 AND alias1.f10 id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t2 ALL NULL NULL NULL NULL 2 Using where 2 MATERIALIZED alias1 ALL NULL NULL NULL NULL 2 Using where -2 MATERIALIZED alias2 ALL NULL NULL NULL NULL 2 Using where; Using join buffer (flat, BNL join) +2 MATERIALIZED alias2 hash_ALL NULL #hash#$hj 4 test.alias1.f11 2 Using where; Using join buffer (flat, BNLH join) SELECT * FROM t2 WHERE ( f12 ) IN ( SELECT alias2.f3 @@ -284,7 +284,7 @@ WHERE (alias2.f10 = alias1.f11) AND (alias1.f11 OR alias1.f3 = 50 AND alias1.f10 id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t2 ALL NULL NULL NULL NULL 2 Using where 2 MATERIALIZED alias1 ALL NULL NULL NULL NULL 2 Using where -2 MATERIALIZED alias2 ALL NULL NULL NULL NULL 2 Using where; Using join buffer (flat, BNL join) +2 MATERIALIZED alias2 hash_ALL NULL #hash#$hj 4 test.alias1.f11 2 Using where; Using join buffer (flat, BNLH join) SELECT * FROM t2 WHERE ( f12 ) IN ( SELECT alias2.f3 @@ -363,7 +363,7 @@ AND a = SOME (SELECT b FROM t5)); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t3 ALL NULL NULL NULL NULL 2 Using where 2 DEPENDENT SUBQUERY t5 index c c 10 NULL 2 Using where; Using index; Start temporary -2 DEPENDENT SUBQUERY t4 eq_ref PRIMARY PRIMARY 4 test.t5.b 1 Using index condition; Using where; End temporary +2 DEPENDENT SUBQUERY t4 hash_ALL PRIMARY #hash#PRIMARY 4 test.t5.b 2 Using where; End temporary; Using join buffer (flat, BNLH join) SELECT * FROM t3 WHERE t3.b > ALL ( |