1. 01 Jun, 2007 2 commits
    • unknown's avatar
      Merge mysql.com:/home/svoj/devel/mysql/BUG28574/mysql-4.1-engines · 12d55a8c
      unknown authored
      into  mysql.com:/home/svoj/devel/mysql/BUG28574/mysql-5.0-engines
      
      
      sql/lock.cc:
        SCCS merged
      12d55a8c
    • unknown's avatar
      BUG#28574 - repair table causes queries to fail with various · 93b10124
      unknown authored
                  corruption errors: 126,134,145
      
      When one thread attempts to lock two (or more) tables and another
      thread executes statement that aborts these locks (e.g. REPAIR
      TABLE) we may get a table object with wrong lock type in a table
      cache.
      
      For example if SELECT FROM t1,t2 was aborted, subsequent INSERT
      INTO t1 may be executed under read lock.
      
      As a result we may get various table corruptions and even a server
      crash.
      
      This is fixed by resetting lock type in case lock was aborted by
      another thread.
      
      I failed to create reasonable test case for this bug.
      
      
      sql/lock.cc:
        If thr_multi_lock was aborted by another thread, it unlocks tables
        that were locked before one that was aborted. Lock type for tables
        that were after a table that was aborted preserved. Thus we need
        to reset lock data in case thr_multi_lock was aborted.
      93b10124
  2. 31 May, 2007 2 commits
    • unknown's avatar
      Merge chilla.local:/home/mydev/mysql-5.0-bug23068 · a471267a
      unknown authored
      into  chilla.local:/home/mydev/mysql-5.0-axmrg
      
      
      sql/mysqld.cc:
        Auto merged
      a471267a
    • unknown's avatar
      Bug#28478 - Improper key_cache_block_size corrupts MyISAM tables · 489a3fe4
      unknown authored
      Setting a key_cache_block_size which is not a power of 2
      could corrupt MyISAM tables.
      
      A couple of computations in the key cache code use bit
      operations which do only work if key_cache_block_size
      is a power of 2.
      
      Replaced bit operations by arithmetic operations
      to make key cache able to handle block sizes that are
      not a power of 2.
      
      
      include/keycache.h:
        Bug#28478 - Improper key_cache_block_size corrupts MyISAM tables
        Removed element 'key_cache_shift' from KEY_CACHE after
        the changes in mf_keycache.c made it unused.
      mysql-test/r/key_cache.result:
        Bug#28478 - Improper key_cache_block_size corrupts MyISAM tables
        Added test result
      mysql-test/t/key_cache.test:
        Bug#28478 - Improper key_cache_block_size corrupts MyISAM tables
        Added test
      mysys/mf_keycache.c:
        Bug#28478 - Improper key_cache_block_size corrupts MyISAM tables
        Replaced bit operations by arithmetic operations
        to make key cache able to handle block sizes that are
        not a power of 2.
      489a3fe4
  3. 24 May, 2007 3 commits
  4. 23 May, 2007 5 commits
  5. 22 May, 2007 6 commits
  6. 21 May, 2007 6 commits
  7. 19 May, 2007 2 commits
    • unknown's avatar
      Merge pilot.blaudden:/home/msvensson/mysql/bug28401/my50-bug28401 · f40047df
      unknown authored
      into  pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint
      
      
      f40047df
    • unknown's avatar
      Bug #28401 mysql_upgrade Failed with STRICT_ALL_TABLES, ANSI_QUOTES and NO_ZERO_DATE · f52f931f
      unknown authored
       - The SQL commands used by mysql_upgrade are written to be run
          with sql_mode set to '' - thus the scripts should change sql_mode
          for the session to make sure the SQL is legal.
      
      
      mysql-test/r/mysql_upgrade.result:
        Update test result
      mysql-test/t/mysql_upgrade.test:
        The SQL commands used by mysql_upgrade are written to be run
        with sql_mode set to '' - thus the scripts should change sql_mode
        for the session to make sure the SQL is legal.
      scripts/mysql_system_tables_fix.sql:
        Set sql_mode to '' before running the SQL commands
        to fix system tables - backport from 5.1
      f52f931f
  8. 18 May, 2007 14 commits