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/r/join_nested_jcl6.result | |
| 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/r/join_nested_jcl6.result')
| -rw-r--r-- | mysql-test/r/join_nested_jcl6.result | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/r/join_nested_jcl6.result b/mysql-test/r/join_nested_jcl6.result index d2c811cea7d..d80beb44ef5 100644 --- a/mysql-test/r/join_nested_jcl6.result +++ b/mysql-test/r/join_nested_jcl6.result @@ -1,4 +1,5 @@ set @save_optimizer_switch_jcl6=@@optimizer_switch; +set @@optimizer_switch='optimize_join_buffer_size=on'; set @@optimizer_switch='semijoin_with_cache=on'; set @@optimizer_switch='outer_join_with_cache=on'; set @@optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; |