1. 19 Nov, 2007 5 commits
    • evgen@moonbone.local's avatar
      Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 6f6fe52a
      evgen@moonbone.local authored
      into  moonbone.local:/work/31048-bug-5.0-opt-mysql
      6f6fe52a
    • evgen@moonbone.local's avatar
      Bug#31048: Many nested subqueries may cause server crash. · 67cae0d4
      evgen@moonbone.local authored
      This bug is actually two. The first one manifests itself on an EXPLAIN
      SELECT query with nested subqueries that employs the filesort algorithm.
      The whole SELECT under explain is marked as UNCACHEABLE_EXPLAIN to preserve
      some temporary structures for explain. As a side-effect of this values of
      nested subqueries weren't cached and subqueries were re-evaluated many
      times. Each time buffer for filesort was allocated but wasn't freed because
      freeing occurs at the end of topmost SELECT. Thus all available memory was
      eaten up step by step and OOM event occur.
      The second bug manifests itself on SELECT queries with conditions where
      a subquery result is compared with a key field and the subquery itself also
      has such condition. When a long chain of such nested subqueries is present
      the stack overrun occur. This happens because at some point the range optimizer
      temporary puts the PARAM structure on the stack. Its size if about 8K and
      the stack is exhausted very fast.
      
      Now the subselect_single_select_engine::exec function allows subquery result
      caching when the UNCACHEABLE_EXPLAIN flag is set.
      Now the SQL_SELECT::test_quick_select function calls the check_stack_overrun
      function for stack checking purposes to prevent server crash.
      67cae0d4
    • gshchepa/uchum@gleb.loc's avatar
      Fixed bug #32282: TEXT silently truncates when value is exactly 65536 · fedeec6c
      gshchepa/uchum@gleb.loc authored
      bytes length.
      
      The server has been modified to report warnings on truncation to
      65536 bytes as usual.
      fedeec6c
    • kaa@polly.(none)'s avatar
      Merge polly.(none):/home/kaa/src/opt/bug32376/my50-bug26215 · ee1bb663
      kaa@polly.(none) authored
      into  polly.(none):/home/kaa/src/opt/mysql-5.0-opt
      ee1bb663
    • kaa@polly.(none)'s avatar
      Changed the help text for --comments to make it clear which option · b93bbc5e
      kaa@polly.(none) authored
      disables the option explicitely.
      Changed the option location in code so that --help will show it in
      lexical option order.
      
      This is for bug #26215: mysql command line client should not strip
      comments from SQL statements
      b93bbc5e
  2. 17 Nov, 2007 7 commits
  3. 16 Nov, 2007 4 commits
  4. 15 Nov, 2007 1 commit
  5. 14 Nov, 2007 4 commits
  6. 13 Nov, 2007 6 commits
  7. 12 Nov, 2007 10 commits
  8. 10 Nov, 2007 3 commits