• unknown's avatar
    Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash · 7d183320
    unknown authored
    Version for 4.0.
    It fixes two problems:
    1. The cause of the bug was that we did not check the table version for
       the HANDLER ... READ commands. We did not notice when a table was
       replaced by a new one. This can happen during ALTER TABLE, REPAIR
       TABLE, and OPTIMIZE TABLE (there might be more cases). I call the fix
       for this problem "the primary bug fix".
    2. mysql_ha_flush() was not always called with a locked LOCK_open.
       Though the function comment clearly said it must.
       I changed the code so that the locking is done when required. I call
       the fix for this problem "the secondary fix".
    
    
    mysql-test/r/handler.result:
      Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
      The test result.
    mysql-test/t/handler.test:
      Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
      The test case.
    sql/mysql_priv.h:
      Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
      Changed a definition for the secondary fix.
    sql/sql_base.cc:
      Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
      Changed function calls for the secondary fix.
    sql/sql_class.cc:
      Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
      Changed a function call for the secondary fix.
    sql/sql_handler.cc:
      Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
      The first two diffs make the primary bug fix.
      The rest is for the secondary fix.
    sql/sql_table.cc:
      Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
      Changed function calls for the secondary fix.
    7d183320
sql_base.cc 67.3 KB