1. 28 Nov, 2011 4 commits
  2. 27 Nov, 2011 3 commits
    • Sergei Golubchik's avatar
      merged · ac8dd6be
      Sergei Golubchik authored
      ac8dd6be
    • Sergei Golubchik's avatar
      compilation fixes · dfc1901e
      Sergei Golubchik authored
      cmake/maintainer.cmake:
        don't do -Werror just yet
      config.h.cmake:
        according to MSDN PSAPI_VERSION should be 1 in a portable application
      mysys/my_thr_init.c:
        first, reset THR_KEY_mysys, and then free dbug data,
        because dbug data are automacially created on the next dbug call,
        unless THR_KEY_mysys is null.
      dfc1901e
    • Sergei Golubchik's avatar
      5.3->5.5 merge · effed09b
      Sergei Golubchik authored
      effed09b
  3. 26 Nov, 2011 2 commits
    • Vladislav Vaintroub's avatar
    • Vladislav Vaintroub's avatar
      Fix build and packaging on Windows: · 64e308e2
      Vladislav Vaintroub authored
      - build executables we have in 5.3 (mysql_install_db.exe, mysq_upgrade_service.exe, upgrade wizard), and MSI
      
      - add some missing headers to windows specific source files. 
      This needs to be done since 5.5 is using WIN32_LEAN_AND_MEAN preprocessor constant thus windows.h 
      no more includes whiole Windows
      
      - do not deliver perl scripts  (mysql_install_db.pl & friends)  -they do not work, are not documented, and we 
      have native executables for this functionality. do not pack echo.exe, replace.exe  into MSI, they 
      are not needed. Do not build resolveip on Windows, it is not used.
      
      - precache results of  of system checks in cmake/os/WindowsCache.cmake (like it is alreay done for  majority of tests
      to speed up cmake run with VS)
      
      - make feedback plugin DEFAULT on Windows (so MSI works if user enables plugin), 
      fix null pointer access in PSI_register
      64e308e2
  4. 25 Nov, 2011 1 commit
    • Vladislav Vaintroub's avatar
      Avoid mysqld dependency on libaio.so by linking xtradb statically to libaio. · 6be24a77
      Vladislav Vaintroub authored
      A variable XTRADB_PREFER_STATIC_LIBAIO should be set to 1 (or TRUE
       or ON) for static linking.
      
      Even if mysqld can avoid dependency on shared libaio, shared libraries 
      libmysqld.so or ha_innodb.so cannot link without it.
      
      Given that the patch primarily addresses building tar.gz package, and 
      shared libraries mentioned above deemed less important than mysqld
      executable, we accept shared lib dependency on libaio.so
      6be24a77
  5. 23 Nov, 2011 3 commits
  6. 22 Nov, 2011 6 commits
  7. 21 Nov, 2011 9 commits
    • unknown's avatar
      Correct test file. · 3e7bcc80
      unknown authored
      3e7bcc80
    • unknown's avatar
      Fix test to pass on 32-bit machines by reducing · b9d6bff8
      unknown authored
      the depth of subquery nestedness to less than 31
      (sizeof(ulong)-1).
      b9d6bff8
    • Igor Babaev's avatar
      Merge. · 76d03e7a
      Igor Babaev authored
      76d03e7a
    • Igor Babaev's avatar
      Fixed LP bug #887496. · b2e5a3f6
      Igor Babaev authored
      This bug in the function Loose_scan_opt::check_ref_access_part1 could lead
      to choosing an invalid execution plan employing a loose scan access to a
      semi-join table even in the cases when such access could not be used at all.
      This could result in wrong answers for some queries with IN subqueries.
      b2e5a3f6
    • unknown's avatar
      Fix bug lp:833777 · f8dbbc01
      unknown authored
      Analysis:
      The optimizer distinguishes two kinds of 'constant' conditions:
      expensive ones, and non-expensive ones. The non-expensive conditions
      are evaluated inside make_join_select(), and if false, already the
      optimizer detects empty query results.
      
      In order to avoid arbitrarily expensive optimization, the evaluation of
      expensive constant conditions is delayed until execution. These conditions
      are attached to JOIN::exec_const_cond and evaluated in the beginning of
      JOIN::exec. The relevant execution logic is:
      
      JOIN::exec()
      {
        if (! join->exec_const_cond->val_int())
        {
          produce an empty result;
          stop execution
        }
        continue execution
        execute the original WHERE clause (that contains exec_const_cond)
       ...
      }
      
      As a result, when an expensive constant condition is
      TRUE, it is evaluated twice - once through
      JOIN::exec_const_cond, and once through JOIN::cond.
      When the expensive constant condition is a subquery,
      predicate, the subquery is evaluated twice. If we have
      many levels of subqueries, this logic results in a chain
      of recursive subquery executions that walk a perfect
      binary tree. The result is that for subquries with depth N,
      JOIN::exec is executed O(2^N) times.
      
      Solution:
      Notice that the second execution of the constant conditions
      happens inside do_select(), in the branch:
      if (join->table_count == join->const_tables) { ... }
      In this case exec_const_cond is equivalent to the whole WHERE
      clause, therefore the WHERE clause has already been checked in
      the beginnig of JOIN::exec, and has been found to be true.
      The bug is addressed by not evaluating the WHERE clause if there
      was exec_const_conds, and it was TRUE.
      f8dbbc01
    • unknown's avatar
      Merge enabling materialization=on by default. · e9a6502f
      unknown authored
      e9a6502f
    • Igor Babaev's avatar
      Corrected the patch that made the optimizer switch for index condition pushdown · 0693f4d9
      Igor Babaev authored
      set to 'on' by default.
      0693f4d9
    • unknown's avatar
    • Igor Babaev's avatar
  8. 20 Nov, 2011 2 commits
    • Igor Babaev's avatar
      Fixed LP bug #892725. · 3c496ea9
      Igor Babaev authored
      A non-first execution of a prepared statement missed a call of the
      TABLE_LIST::process_index_hints() method in the code of the function
      setup_tables().
      At some scenarios this could lead to the choice of a quite inefficient
      execution plan for the base query of the prepared statement.
      3c496ea9
    • Alexey Botchkov's avatar
      Fix for bug #809849 spatial operations must be KILL-able. · 5a4c9100
      Alexey Botchkov authored
        Checks for thd->killed state added to the long loops in geometry calculations.
      
      per-file comments:
        sql/gcalc_slicescan.cc
      Fix for bug #809849 spatial operations must be KILL-able.
              checks for TERMINATED_STATE added.
        sql/gcalc_slicescan.h
      Fix for bug #809849 spatial operations must be KILL-able.
              defines added to include checks for termination in the
              library.
        sql/gcalc_tools.cc
      Fix for bug #809849 spatial operations must be KILL-able.
              checks for TERMINATED_STATE added.
        sql/gcalc_tools.h
      Fix for bug #809849 spatial operations must be KILL-able.
              TERMINATED_STATE pointers added.
        sql/item_geofunc.cc
      Fix for bug #809849 spatial operations must be KILL-able.
        sql/item_geofunc.h
      Fix for bug #809849 spatial operations must be KILL-able.
      5a4c9100
  9. 18 Nov, 2011 5 commits
    • Igor Babaev's avatar
      Fixed LP bug #891995. · 8ea39829
      Igor Babaev authored
      This bug in the function setup_semijoin_dups_elimination() could 
      lead to invalid choice of the sequence of tables for which semi-join
      duplicate elimination was applied.
      8ea39829
    • Igor Babaev's avatar
      Fixed LP bug #891953. · 6ed9c136
      Igor Babaev authored
      Due to this bug the function SEL_IMERGE::or_sel_tree_with_checks()
      could build an inconsistent merge tree if one of the SEL_TREEs in the
      resulting index merge happened to contain a full key range.
      This could trigger an assertion failure.
      
      
      
      6ed9c136
    • Alexey Botchkov's avatar
      unused variable removed. · fbb22ca4
      Alexey Botchkov authored
      fbb22ca4
    • Alexey Botchkov's avatar
      GCALC_CHECK_WITH_FLOAT disabled. · 47022d2e
      Alexey Botchkov authored
      That's not a good option for an onrdinary user.
      47022d2e
    • Igor Babaev's avatar
      Fixed LP bug #800184. · 3433cf3e
      Igor Babaev authored
      The function key_and() erroneously called SEL_ARG::increment_use_count()
      when SEL_ARG::incr_refs() should had been called. This could lead to
      wrong values of use_count for some SEL_ARG trees.
      3433cf3e
  10. 17 Nov, 2011 5 commits