• Jon Olav Hauglid's avatar
    Bug #53798 OPTIMIZE TABLE breaks repeatable read · e7e5118f
    Jon Olav Hauglid authored
    The problem was that OPTMIZE TABLE was allowed to run on a table
    in use by a transaction in a different connection. This caused
    repeatable read to break.
    
    This bug was fixed by the introduction of metadata locking, WL#4284.
    OPTIMIZE TABLE will now be blocked until the transaction using the
    table, has ended.
    
    This patch contains a regression test added to innodb_mysql_lock.test
    and no code changes.
    e7e5118f
innodb_mysql_lock.result 3.05 KB