summaryrefslogtreecommitdiff
path: root/mysql-test/r/join_outer_innodb.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/join_outer_innodb.result')
-rw-r--r--mysql-test/r/join_outer_innodb.result88
1 files changed, 44 insertions, 44 deletions
diff --git a/mysql-test/r/join_outer_innodb.result b/mysql-test/r/join_outer_innodb.result
index 6f3fb09329d..6e6eb07b69a 100644
--- a/mysql-test/r/join_outer_innodb.result
+++ b/mysql-test/r/join_outer_innodb.result
@@ -9,13 +9,13 @@ SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id
WHERE t1.name LIKE 'A%';
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 index PRIMARY,name name 23 NULL 3 Using where; Using index
-1 SIMPLE t2 ref fkey fkey 5 test.t1.id 1 Using index
+1 SIMPLE t2 hash_index fkey #hash#fkey:fkey 5:5 test.t1.id 5 Using index; Using join buffer (flat, BNLH join)
EXPLAIN
SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id
WHERE t1.name LIKE 'A%' OR FALSE;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 index PRIMARY,name name 23 NULL 3 Using where; Using index
-1 SIMPLE t2 ref fkey fkey 5 test.t1.id 1 Using index
+1 SIMPLE t2 hash_index fkey #hash#fkey:fkey 5:5 test.t1.id 5 Using index; Using join buffer (flat, BNLH join)
DROP TABLE t1,t2;
#
# BUG#58456: Assertion 0 in QUICK_INDEX_MERGE_SELECT::need_sorted_output
@@ -134,9 +134,9 @@ WHERE t6b.col_int_key IS TRUE;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t6a ALL NULL NULL NULL NULL 1 Using where
1 SIMPLE t1 ALL NULL NULL NULL NULL 1 Using join buffer (flat, BNL join)
-1 SIMPLE t4 ALL NULL NULL NULL NULL 1 Using where; Using join buffer (incremental, BNL join)
+1 SIMPLE t4 hash_ALL NULL #hash#$hj 5 test.t1.pk 1 Using where; Using join buffer (incremental, BNLH join)
1 SIMPLE t3 ALL NULL NULL NULL NULL 1 Using join buffer (incremental, BNL join)
-1 SIMPLE t5 ALL NULL NULL NULL NULL 1 Using where; Using join buffer (incremental, BNL join)
+1 SIMPLE t5 hash_ALL NULL #hash#$hj 5 test.t1.pk 1 Using where; Using join buffer (incremental, BNLH join)
1 SIMPLE t6b ALL NULL NULL NULL NULL 1 Using where; Using join buffer (incremental, BNL join)
1 SIMPLE t2 ALL NULL NULL NULL NULL 1 Using where; Using join buffer (incremental, BNL join)
SELECT t6a.pk, t2.pk
@@ -180,9 +180,9 @@ WHERE t6b.col_int_key IS TRUE;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t6a ALL NULL NULL NULL NULL 1 Using where
1 SIMPLE t1 ALL NULL NULL NULL NULL 1 Using join buffer (flat, BNL join)
-1 SIMPLE t4 ALL NULL NULL NULL NULL 1 Using where; Using join buffer (incremental, BNL join)
+1 SIMPLE t4 hash_ALL NULL #hash#$hj 5 test.t1.pk 1 Using where; Using join buffer (incremental, BNLH join)
1 SIMPLE t3 ALL NULL NULL NULL NULL 1 Using join buffer (incremental, BNL join)
-1 SIMPLE t5 ALL NULL NULL NULL NULL 1 Using where; Using join buffer (incremental, BNL join)
+1 SIMPLE t5 hash_ALL NULL #hash#$hj 5 test.t1.pk 1 Using where; Using join buffer (incremental, BNLH join)
1 SIMPLE t6b ALL NULL NULL NULL NULL 1 Using where; Using join buffer (incremental, BNL join)
1 SIMPLE t2 ALL NULL NULL NULL NULL 1 Using where; Using join buffer (incremental, BNL join)
drop table t1,t2,t3,t4,t5,t6;
@@ -433,47 +433,47 @@ left join t16 on t15.o1 = t16.p1
where t1.a10 = 1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL a4,a6,a5,a7 NULL NULL NULL 3 Using where
-1 SIMPLE t2 ref PRIMARY PRIMARY 4 test.t1.a1 1 Using index
-1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.b2 1 Using where; Using index
-1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t1.a2 1 Using index
-1 SIMPLE t5 eq_ref PRIMARY PRIMARY 4 test.t4.d1 1 Using where
-1 SIMPLE t6 eq_ref PRIMARY PRIMARY 4 test.t1.a3 1 Using where; Using index
-1 SIMPLE t8 eq_ref PRIMARY PRIMARY 1 test.t1.a4 1 Using index
-1 SIMPLE t7 eq_ref PRIMARY PRIMARY 1 test.t1.a7 1
-1 SIMPLE t9 ref PRIMARY PRIMARY 1 test.t1.a4 1
-1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t1.a5 1
-1 SIMPLE t12 eq_ref PRIMARY PRIMARY 4 test.t11.k3 1 Using where
-1 SIMPLE l2 eq_ref PRIMARY PRIMARY 4 test.t11.k4 1 Using where
-1 SIMPLE t13 ref PRIMARY,m3 PRIMARY 4 test.t1.a1 1 Using where; Using index
-1 SIMPLE l4 eq_ref PRIMARY PRIMARY 4 test.t13.m2 1 Using where; Using index
-1 SIMPLE m2 ref PRIMARY,m3 PRIMARY 4 test.t1.a1 1 Using where; Using index
-1 SIMPLE l3 eq_ref PRIMARY PRIMARY 4 test.m2.m2 1 Using where
-1 SIMPLE t14 eq_ref PRIMARY PRIMARY 2 test.t1.a8 1 Using where
-1 SIMPLE t15 eq_ref PRIMARY PRIMARY 2 test.t1.a9 1 Using where; Using index
-1 SIMPLE t16 ref PRIMARY PRIMARY 2 test.t15.o1 1 Using where
-1 SIMPLE t10 ALL PRIMARY NULL NULL NULL 3 Using where; Using join buffer (flat, BNL join)
+1 SIMPLE t2 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:8 test.t1.a1 1 Using index; Using join buffer (flat, BNLH join)
+1 SIMPLE t3 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t2.b2 17 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t4 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t1.a2 5 Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t5 hash_ALL PRIMARY #hash#PRIMARY 4 test.t4.d1 3 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t6 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t1.a3 3 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t8 hash_index PRIMARY #hash#PRIMARY:PRIMARY 1:1 test.t1.a4 4 Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t7 hash_ALL PRIMARY #hash#PRIMARY 1 test.t1.a7 6 Using join buffer (incremental, BNLH join)
+1 SIMPLE t9 hash_index PRIMARY #hash#PRIMARY:i3 1:388 test.t1.a4 8 Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t11 hash_ALL PRIMARY #hash#PRIMARY 4 test.t1.a5 22 Using join buffer (incremental, BNLH join)
+1 SIMPLE t12 hash_ALL PRIMARY #hash#PRIMARY 4 test.t11.k3 3 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE l2 hash_ALL PRIMARY #hash#PRIMARY 4 test.t11.k4 3 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t13 hash_index PRIMARY,m3 #hash#PRIMARY:PRIMARY 4:12 test.t1.a1 3 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE l4 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t13.m2 3 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE m2 hash_index PRIMARY,m3 #hash#PRIMARY:PRIMARY 4:12 test.t1.a1 3 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE l3 hash_ALL PRIMARY #hash#PRIMARY 4 test.m2.m2 3 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t14 hash_ALL PRIMARY #hash#PRIMARY 2 test.t1.a8 4 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t15 hash_index PRIMARY #hash#PRIMARY:PRIMARY 2:2 test.t1.a9 2 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t16 hash_ALL PRIMARY #hash#PRIMARY 2 test.t15.o1 4 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t10 ALL PRIMARY NULL NULL NULL 3 Using where; Using join buffer (incremental, BNL join)
explain select * from v1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL a4,a6,a5,a7 NULL NULL NULL 3 Using where
-1 SIMPLE t2 ref PRIMARY PRIMARY 4 test.t1.a1 1 Using index
-1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.b2 1 Using where; Using index
-1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t1.a2 1 Using index
-1 SIMPLE t5 eq_ref PRIMARY PRIMARY 4 test.t4.d1 1 Using where
-1 SIMPLE t6 eq_ref PRIMARY PRIMARY 4 test.t1.a3 1 Using where; Using index
-1 SIMPLE t8 eq_ref PRIMARY PRIMARY 1 test.t1.a4 1 Using index
-1 SIMPLE t7 eq_ref PRIMARY PRIMARY 1 test.t1.a7 1
-1 SIMPLE t9 ref PRIMARY PRIMARY 1 test.t1.a4 1
-1 SIMPLE t11 eq_ref PRIMARY PRIMARY 4 test.t1.a5 1
-1 SIMPLE t12 eq_ref PRIMARY PRIMARY 4 test.t11.k3 1 Using where
-1 SIMPLE l2 eq_ref PRIMARY PRIMARY 4 test.t11.k4 1 Using where
-1 SIMPLE t13 ref PRIMARY,m3 PRIMARY 4 test.t1.a1 1 Using where; Using index
-1 SIMPLE l4 eq_ref PRIMARY PRIMARY 4 test.t13.m2 1 Using where; Using index
-1 SIMPLE m2 ref PRIMARY,m3 PRIMARY 4 test.t1.a1 1 Using where; Using index
-1 SIMPLE l3 eq_ref PRIMARY PRIMARY 4 test.m2.m2 1 Using where
-1 SIMPLE t14 eq_ref PRIMARY PRIMARY 2 test.t1.a8 1 Using where
-1 SIMPLE t15 eq_ref PRIMARY PRIMARY 2 test.t1.a9 1 Using where; Using index
-1 SIMPLE t16 ref PRIMARY PRIMARY 2 test.t15.o1 1 Using where
-1 SIMPLE t10 ALL PRIMARY NULL NULL NULL 3 Using where; Using join buffer (flat, BNL join)
+1 SIMPLE t2 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:8 test.t1.a1 1 Using index; Using join buffer (flat, BNLH join)
+1 SIMPLE t3 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t2.b2 17 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t4 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t1.a2 5 Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t5 hash_ALL PRIMARY #hash#PRIMARY 4 test.t4.d1 3 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t6 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t1.a3 3 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t8 hash_index PRIMARY #hash#PRIMARY:PRIMARY 1:1 test.t1.a4 4 Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t7 hash_ALL PRIMARY #hash#PRIMARY 1 test.t1.a7 6 Using join buffer (incremental, BNLH join)
+1 SIMPLE t9 hash_index PRIMARY #hash#PRIMARY:i3 1:388 test.t1.a4 8 Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t11 hash_ALL PRIMARY #hash#PRIMARY 4 test.t1.a5 22 Using join buffer (incremental, BNLH join)
+1 SIMPLE t12 hash_ALL PRIMARY #hash#PRIMARY 4 test.t11.k3 3 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE l2 hash_ALL PRIMARY #hash#PRIMARY 4 test.t11.k4 3 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t13 hash_index PRIMARY,m3 #hash#PRIMARY:PRIMARY 4:12 test.t1.a1 3 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE l4 hash_index PRIMARY #hash#PRIMARY:PRIMARY 4:4 test.t13.m2 3 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE m2 hash_index PRIMARY,m3 #hash#PRIMARY:PRIMARY 4:12 test.t1.a1 3 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE l3 hash_ALL PRIMARY #hash#PRIMARY 4 test.m2.m2 3 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t14 hash_ALL PRIMARY #hash#PRIMARY 2 test.t1.a8 4 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t15 hash_index PRIMARY #hash#PRIMARY:PRIMARY 2:2 test.t1.a9 2 Using where; Using index; Using join buffer (incremental, BNLH join)
+1 SIMPLE t16 hash_ALL PRIMARY #hash#PRIMARY 2 test.t15.o1 4 Using where; Using join buffer (incremental, BNLH join)
+1 SIMPLE t10 ALL PRIMARY NULL NULL NULL 3 Using where; Using join buffer (incremental, BNL join)
drop view v1;
drop table t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16;
#
View Lorry Controller Status