1. 08 Mar, 2007 2 commits
    • istruewing@chilla.local's avatar
      Merge chilla.local:/home/mydev/mysql-4.1-bug25673 · 76071475
      istruewing@chilla.local authored
      into  chilla.local:/home/mydev/mysql-5.0-bug25673
      76071475
    • istruewing@chilla.local's avatar
      Bug#25673 - spatial index corruption, error 126 · 2d6ad76a
      istruewing@chilla.local authored
                incorrect key file for table
      
      In certain cases it could happen that deleting a row could
      corrupt an RTREE index.
      
      According to Guttman's algorithm, page underflow is handled
      by storing the page in a list for later re-insertion. The
      keys from the stored pages have to be inserted into the
      remaining pages of the same level of the tree. Hence the
      level number is stored in the re-insertion list together
      with the page.
      
      In the MySQL RTree implementation the level counts from zero
      at the root page, increasing numbers for levels down the tree.
      
      If during re-insertion of the keys the tree height grows, all
      level numbers become invalid. The remaining keys will be
      inserted at the wrong level.
      
      The fix is to increment the level numbers stored in the
      reinsert list after a split of the root block during reinsertion.
      2d6ad76a
  2. 20 Feb, 2007 1 commit
  3. 16 Feb, 2007 1 commit
  4. 14 Feb, 2007 3 commits
  5. 13 Feb, 2007 9 commits
  6. 12 Feb, 2007 17 commits
  7. 11 Feb, 2007 3 commits
  8. 09 Feb, 2007 4 commits
    • evgen@moonbone.local's avatar
      Bug#12122: The MERGE algorithm isn't applicable if the ORDER BY clause is · a2414463
      evgen@moonbone.local authored
      present.
      
      A view created with CREATE VIEW ... ORDER BY ... cannot be resolved with
      the MERGE algorithm, even when no other part of the CREATE VIEW statement
      would require the view to be resolved using the TEMPTABLE algorithm.
      
      The check for presence of the ORDER BY clause in the underlying select is 
      removed from the st_lex::can_be_merged() function.
      The ORDER BY list of the underlying select is appended to the ORDER BY list 
      a2414463
    • igor@olga.mysql.com's avatar
      Merge olga.mysql.com:/home/igor/mysql-5.0-opt · 3fe9de28
      igor@olga.mysql.com authored
      into  olga.mysql.com:/home/igor/dev-opt/mysql-5.0-opt-bug26017
      3fe9de28
    • igor@olga.mysql.com's avatar
      Fixed bug #26017. · 951fe3ca
      igor@olga.mysql.com authored
      Objects of the class Item_equal contain an auxiliary member
      eval_item of the type cmp_item that is used only for direct 
      evaluation of multiple equalities. Currently a multiple equality
      is evaluated directly only in the cases when the equality holds
      at most for one row in the result set.
      The compare collation of eval_item was determined incorectly.
      It could lead to returning incorrect results for some queries.
      951fe3ca
    • evgen@moonbone.local's avatar
      Bug#23170: LAST_INSERT_ID isn't reset to 0 in INSERT .. SELECT when no rows were · 380c2205
      evgen@moonbone.local authored
      inserted.
      
      The select_insert::send_eof() function now resets LAST_INSERT_ID variable if
      no rows were inserted.
      380c2205