main.subselect_sj2_jcl6 'innodb_plugin' w1 [ fail ]
|
Test ended at 2015-03-17 20:35:53
|
|
CURRENT_TEST: main.subselect_sj2_jcl6
|
--- /usr/local/mariadb-5.5.42-linux-x86_64/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.result~ 2015-03-17 20:35:53.000000000 +0100
|
+++ /usr/local/mariadb-5.5.42-linux-x86_64/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.reject 2015-03-17 20:35:53.000000000 +0100
|
@@ -1272,7 +1272,7 @@
|
);
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 PRIMARY T3_0_ ref PRIMARY,FK_T3_T2Id PRIMARY 8 const 3 Using index; Start temporary
|
-1 PRIMARY T2_1_ eq_ref PRIMARY,FK_T2_T1Id PRIMARY 8 test.T3_0_.t2idref 1 Using join buffer (flat, BKA join); Key-ordered scan
|
+1 PRIMARY T2_1_ eq_ref PRIMARY,FK_T2_T1Id PRIMARY 8 test.T3_0_.t2idref 1
|
1 PRIMARY T1_1_ eq_ref PRIMARY PRIMARY 8 test.T2_1_.t1idref 1 Using index
|
1 PRIMARY T2_0_ ref FK_T2_T1Id FK_T2_T1Id 8 test.T2_1_.t1idref 1 Using index; End temporary
|
drop table t3,t2,t1;
|