diff options
Diffstat (limited to 'mysql-test/r/subselect_sj2_jcl6.result')
| -rw-r--r-- | mysql-test/r/subselect_sj2_jcl6.result | 9 |
1 files changed, 3 insertions, 6 deletions
diff --git a/mysql-test/r/subselect_sj2_jcl6.result b/mysql-test/r/subselect_sj2_jcl6.result index 67215d1715e..8e3ec975b35 100644 --- a/mysql-test/r/subselect_sj2_jcl6.result +++ b/mysql-test/r/subselect_sj2_jcl6.result @@ -64,7 +64,7 @@ a b pk1 pk2 pk3 set @save_max_heap_table_size= @@max_heap_table_size; set max_heap_table_size=16384; set @save_join_buffer_size = @@join_buffer_size; -set join_buffer_size= 8000; +set join_buffer_size= 8192; drop table t3; create table t3 ( a int, @@ -79,10 +79,8 @@ from t0 A, t0 B where B.a <5; explain select * from t3 where b in (select a from t0); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY subselect2 ALL unique_key NULL NULL NULL 10 -1 PRIMARY t3 ref b b 5 test.t0.a 1 Using join buffer +1 PRIMARY t3 ref b b 5 test.t0.a 1 2 SUBQUERY t0 ALL NULL NULL NULL NULL 10 -set @save_ecp= @@engine_condition_pushdown; -set engine_condition_pushdown=0; select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5); a b pk1 pk2 0 0 0 0 @@ -99,7 +97,6 @@ a b pk1 pk2 11 11 11 11 12 12 12 12 13 13 13 13 -set engine_condition_pushdown=@save_ecp; set join_buffer_size= @save_join_buffer_size; set max_heap_table_size= @save_max_heap_table_size; explain select * from t1 where a in (select b from t2); @@ -119,7 +116,7 @@ a b 2 2 drop table t1, t2, t3; set @save_join_buffer_size = @@join_buffer_size; -set join_buffer_size= 8000; +set join_buffer_size= 8192; create table t1 (a int, filler1 binary(200), filler2 binary(200)); insert into t1 select a, 'filler123456', 'filler123456' from t0; insert into t1 select a+10, 'filler123456', 'filler123456' from t0; |