diff options
author | Igor Babaev <igor@askmonty.org> | 2010-08-31 09:34:21 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2010-08-31 09:34:21 -0700 |
commit | 94cfcbd9dffdfe5e38dd29c542738de85beaeb06 (patch) | |
tree | dca2c84e183cce7a4a08cc82ac696adfc9c244a8 /mysql-test/r/select_jcl6.result | |
parent | 02c040dd5c26cbc97ae30776638463c36d96a938 (diff) | |
download | mariadb-git-94cfcbd9dffdfe5e38dd29c542738de85beaeb06.tar.gz |
The main patch for MWL#128: Implement Block Nested Loop Hash Join.
Diffstat (limited to 'mysql-test/r/select_jcl6.result')
-rwxr-xr-x[-rw-r--r--] | mysql-test/r/select_jcl6.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/select_jcl6.result b/mysql-test/r/select_jcl6.result index ff09e79a511..7ea2744d69b 100644..100755 --- a/mysql-test/r/select_jcl6.result +++ b/mysql-test/r/select_jcl6.result @@ -1,3 +1,6 @@ +set @save_optimizer_switch_jcl6=@@optimizer_switch; +set @@optimizer_switch='semijoin_with_cache=on'; +set @@optimizer_switch='outer_join_with_cache=on'; set join_cache_level=6; show variables like 'join_cache_level'; Variable_name Value @@ -4790,3 +4793,4 @@ set join_cache_level=default; show variables like 'join_cache_level'; Variable_name Value join_cache_level 1 +set @@optimizer_switch=@save_optimizer_switch_jcl6; |