• Sergey Petrunya's avatar
    Change the default @@optimizer_switch setting from · c1de6f8b
    Sergey Petrunya authored
      semijoin=on,firstmatch=on,loosescan=on
    to
      semijoin=off,firstmatch=off,loosescan=off
    Adjust the testcases:
    - Modify subselect*.test and join_cache.test so that all tests
      use the same execution paths as before (i.e. optimizations that
      are being tested are enabled)
    - Let all other test files run with the new default settings (i.e.
      with new optimizations disabled)
    - Copy subquery testcases from these files into t/subselect_extra.test
      which will run them with new optimizations enabled.
    c1de6f8b
subselect_sj_nonmerged.test 3.32 KB