• kevin.lewis@oracle.com's avatar
    Bug#16914007-INNODB: CHECK TABLE SHOULD MARK AN INDEX AS CORRUPTED · 4afea945
    kevin.lewis@oracle.com authored
    IF IT HAS A WRONG COUNT
    
    If CHECK TABLE finds that a secondary index contains the wrong
    number of entries, it used to report an error but not mark the
    index as corrupt. The error means that the index should be rebuilt,
    which can be done with ALTER TABLE DROP INDEX and ALTER TABLE ADD
    INDEX.  But just in case the DBA does not pay any attention to the
    output of CHECK TABLE, the secondary index should be marked as
    corrupted so that it is not used again.
    
    Approved by Inaam in RB:2607
    4afea945
ha_innodb.cc 347 KB