An error occurred fetching the project authors.
  1. 25 Nov, 2011 1 commit
    • Sergey Petrunya's avatar
      Semi-join optimizations code cleanup part 2: · f84dbf4b
      Sergey Petrunya authored
      - Make EXPLAIN display "Start temporary" at the start of the fanout (it used to display
        at the first table whose rowid gets into temp. table which is not that useful for
        the user)
      - Updated test results (all checked)
      f84dbf4b
  2. 25 Oct, 2011 1 commit
    • Igor Babaev's avatar
      Fixed LP bug #881318. · a8f7c03c
      Igor Babaev authored
      If a materialized derived table / view is empty then for this table
      the value of file->ref is 0. This was not taken into account by
      the function JOIN_CACHE::write_record_data. As a result a query
      using an empty materialized derived tables as inner tables of outer
      joins and IN subqueries in WHERE conditions could cause server crashes
      when the optimizer employed join caches and duplicate elimination for
      semi-joins.
      a8f7c03c
  3. 12 Oct, 2011 1 commit
  4. 11 Oct, 2011 2 commits
  5. 01 Oct, 2011 1 commit
  6. 26 Sep, 2011 1 commit
  7. 20 Sep, 2011 1 commit
  8. 08 Jul, 2011 1 commit
    • Sergey Petrunya's avatar
      Set the default to be mrr=off,mrr_sort_keys=off: · 1492de85
      Sergey Petrunya authored
      - Set the default
      - Adjust the testcases so that 'new' tests are run with optimizations turned on.
      - Pull out relevant tests from "irrelevant" tests and run them with optimizations on.
      - Run range.test and innodb.test with both mrr=on and mrr=off
      1492de85
  9. 04 Jul, 2011 1 commit
    • 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
  10. 15 Jun, 2011 1 commit
  11. 20 May, 2011 1 commit
  12. 22 Nov, 2010 1 commit
  13. 03 Oct, 2010 2 commits
  14. 11 May, 2010 1 commit
  15. 07 Mar, 2010 1 commit
    • Sergey Petrunya's avatar
      BUG#49129: Wrong result with IN-subquery with join_cache_level=6 and firstmatch=off · c2924e15
      Sergey Petrunya authored
      - The problem was that DuplicateWeedout strategy setup code wasn't aware of the 
        fact that join buffering will be used and applied optimization that doesn't work
        together with join buffering. Fixed by making DuplicateWeedout setup code to have 
        a pessimistic check about whether there is a chance that join buffering will be 
        used.
      - Make JOIN_CACHE_BKA::init() correctly process Copy_field elements that denote saving
        current rowids in the join buffer.
      
      mysql-test/r/subselect_sj2.result:
        Update test results
      mysql-test/r/subselect_sj2_jcl6.result:
        Update test results
      mysql-test/r/subselect_sj_jcl6.result:
        Testcase
      mysql-test/t/subselect_sj2.test:
        Update test results
      mysql-test/t/subselect_sj_jcl6.test:
        Testcase
      sql/opt_subselect.cc:
        - The problem was that DuplicateWeedout strategy setup code wasn't aware of the 
          fact that join buffering will be used and applied optimization that doesn't work
          together with join buffering. Fixed by making DuplicateWeedout setup code to have 
          a pessimistic check about whether there is a chance that join buffering will be 
          used.
      sql/sql_join_cache.cc:
        Make JOIN_CACHE_BKA::init() correctly process Copy_field elements that denote saving current rowids in the join buffer.
      sql/sql_select.cc:
        Added a question note
      c2924e15
  16. 17 Jan, 2010 1 commit