From 94cfcbd9dffdfe5e38dd29c542738de85beaeb06 Mon Sep 17 00:00:00 2001 From: Igor Babaev Date: Tue, 31 Aug 2010 09:34:21 -0700 Subject: The main patch for MWL#128: Implement Block Nested Loop Hash Join. --- mysql-test/t/subselect3_jcl6.test | 6 ++++++ 1 file changed, 6 insertions(+) mode change 100644 => 100755 mysql-test/t/subselect3_jcl6.test (limited to 'mysql-test/t/subselect3_jcl6.test') diff --git a/mysql-test/t/subselect3_jcl6.test b/mysql-test/t/subselect3_jcl6.test old mode 100644 new mode 100755 index 9ee23288d99..6d9611f83f3 --- a/mysql-test/t/subselect3_jcl6.test +++ b/mysql-test/t/subselect3_jcl6.test @@ -2,6 +2,10 @@ # Run subselect3.test with BKA enabled # +set @save_optimizer_switch=@@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'; @@ -9,3 +13,5 @@ show variables like 'join_cache_level'; set join_cache_level=default; show variables like 'join_cache_level'; + +set @@optimizer_switch=@save_optimizer_switch; -- cgit v1.2.1