1. 28 Aug, 2007 1 commit
    • mhansson/martin@linux-st28.site's avatar
      Bug #30596 GROUP BY optimization gives wrong result order · 98d34d62
      mhansson/martin@linux-st28.site authored
        
      The optimization that uses a unique index to remove GROUP BY did not 
      ensure that the index was actually used, thus violating the ORDER BY
      that is implied by GROUP BY.
      Fixed by replacing GROUP BY with ORDER BY if the GROUP BY clause contains
      a unique index over non-nullable field(s). In case GROUP BY ... ORDER BY 
      null is used, GROUP BY is simply removed.
      98d34d62
  2. 22 Aug, 2007 2 commits
    • gshchepa/uchum@gleb.loc's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt-30201 · 3608dbdc
      gshchepa/uchum@gleb.loc authored
      into  gleb.loc:/home/uchum/work/bk/5.1-opt
      3608dbdc
    • gshchepa/uchum@gleb.loc's avatar
      Fixed bug #30201. · f3d0f62d
      gshchepa/uchum@gleb.loc authored
      Killing a SELECT query with KILL QUERY or KILL CONNECTION
      causes a server crash if the query cache is enabled.
      
      Normal evaluation of a query may be interrupted by the
      KILL QUERY/CONNECTION statement, in this case the mysql_execute_command
      function returns TRUE, and the thd->killed flag has true value.
      In this case the result of the query may
      be cached incompletely (omitting call to query_cache_insert inside
      the net_real_write function), and next call to query_cache_end_of_result
      may lead to server crash.
      Thus, the query_cache_end_of_result function has been modified to abort
      query cache in the case of killed thread.
      f3d0f62d
  3. 21 Aug, 2007 14 commits
  4. 20 Aug, 2007 3 commits
  5. 18 Aug, 2007 5 commits
  6. 17 Aug, 2007 6 commits
  7. 16 Aug, 2007 8 commits
  8. 15 Aug, 2007 1 commit