diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-12-15 15:55:00 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-12-15 15:55:00 -0800 |
| commit | 919f19110fbcfb4326559f48f7ba9fa5c35d904d (patch) | |
| tree | 38024bb9d1d77ac6bc3a1589ce1e1a52ece5f771 /mysql-test/r/subselect3_jcl6.result | |
| parent | 4dd456c220f702aeb0c9c32a52d7fe5c05ddca14 (diff) | |
| parent | 43d9fc32046b1b7ca1a49395f9dd79c145dba215 (diff) | |
| download | mariadb-git-919f19110fbcfb4326559f48f7ba9fa5c35d904d.tar.gz | |
Merge
Diffstat (limited to 'mysql-test/r/subselect3_jcl6.result')
| -rw-r--r-- | mysql-test/r/subselect3_jcl6.result | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/r/subselect3_jcl6.result b/mysql-test/r/subselect3_jcl6.result index 66b305bcf14..c70adc7e71c 100644 --- a/mysql-test/r/subselect3_jcl6.result +++ b/mysql-test/r/subselect3_jcl6.result @@ -7,9 +7,11 @@ set join_cache_level=6; show variables like 'join_cache_level'; Variable_name Value join_cache_level 6 +set @join_cache_level_for_subselect3_test=@@join_cache_level; drop table if exists t0, t1, t2, t3, t4, t5, t11, t12, t21, t22; set @subselect3_tmp= @@optimizer_switch; set optimizer_switch='semijoin=on,firstmatch=on,loosescan=on,semijoin_with_cache=on'; +set join_cache_level=@join_cache_level_for_subselect3_test; create table t1 (oref int, grp int, ie int) ; insert into t1 (oref, grp, ie) values (1, 1, 1), @@ -1502,5 +1504,6 @@ set @@optimizer_switch=@subselect3_tmp; set join_cache_level=default; show variables like 'join_cache_level'; Variable_name Value -join_cache_level 1 +join_cache_level 2 set @@optimizer_switch=@save_optimizer_switch; +set @join_cache_level_for_subselect3_test=NULL; |