diff options
Diffstat (limited to 'mysql-test/r/subselect_sj2.result')
| -rw-r--r-- | mysql-test/r/subselect_sj2.result | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/mysql-test/r/subselect_sj2.result b/mysql-test/r/subselect_sj2.result index f17edf3be6c..00c62920fce 100644 --- a/mysql-test/r/subselect_sj2.result +++ b/mysql-test/r/subselect_sj2.result @@ -60,7 +60,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, @@ -77,8 +77,6 @@ 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 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 @@ -95,7 +93,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); @@ -115,7 +112,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; |