diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-07-14 22:24:59 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-07-14 22:24:59 -0700 |
| commit | 03081bc1fd25ab2f414a4559d709d3ef0ec9b4d8 (patch) | |
| tree | 32a9dabecb4156faabad7d81ebab9ceaae920ef5 /mysql-test/t/join_cache.test | |
| parent | 0aaae1e31d3e747dc631e1275a4269c9a4abae9f (diff) | |
| download | mariadb-git-03081bc1fd25ab2f414a4559d709d3ef0ec9b4d8.tar.gz | |
Changed the default setting of the optimizer switch 'optimize_join_buffer_size'.
Made it 'off' by default.
Diffstat (limited to 'mysql-test/t/join_cache.test')
| -rw-r--r-- | mysql-test/t/join_cache.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/join_cache.test b/mysql-test/t/join_cache.test index 9ccba27e4ee..873fab045df 100644 --- a/mysql-test/t/join_cache.test +++ b/mysql-test/t/join_cache.test @@ -4,6 +4,7 @@ DROP DATABASE IF EXISTS world; --enable_warnings set @save_optimizer_switch=@@optimizer_switch; +set @@optimizer_switch='optimize_join_buffer_size=on'; set optimizer_switch='semijoin=on,firstmatch=on,loosescan=on'; set @@optimizer_switch='semijoin_with_cache=on'; set @@optimizer_switch='outer_join_with_cache=on'; |