1. 18 Oct, 2013 1 commit
    • timour@askmonty.org's avatar
      MDEV-5123 Remove duplicated conditions pushed both to join_tab->select_cond... · afed8092
      timour@askmonty.org authored
      MDEV-5123 Remove duplicated conditions pushed both to join_tab->select_cond and join_tab->cache_select->cond for blocked joins.
          
      BNL and BNLH joins pre-filter the records from a joined table via JOIN_TAB::cache_select->cond.
      There is no need to re-evaluate the same conditions via JOIN_TAB::select_cond. This patch removes
      the duplicated conditions from the top-level conjuncts of each pushed condition.
      
      The added "Using where" in few EXPLAINs is due to taking into account tab->cache_select->cond
      in addition to tab->select_cond in JOIN::save_explain_data_intern.
      afed8092
  2. 21 Oct, 2013 5 commits
  3. 17 Oct, 2013 1 commit
  4. 16 Oct, 2013 12 commits
  5. 15 Oct, 2013 9 commits
  6. 14 Oct, 2013 9 commits
  7. 13 Oct, 2013 2 commits
  8. 12 Oct, 2013 1 commit
    • Igor Babaev's avatar
      Fixed bug mdev-5132. · 78b580b7
      Igor Babaev authored
      Objects of the classes Item_func_isnull and Item_func_isnotnull
      must have the flag sargable set to TRUE.
      Set the value of the flag sargable only in constructors of the 
      classes inherited from Item_int_func.
      78b580b7