• Ramil Kalimullin's avatar
    Fix for bug#37527: mysqlcheck fails to report entire database · e3de8d36
    Ramil Kalimullin authored
    when InnoDB frm file corruption
    
    Problem: mysqlcheck runs 'SHOW FULL TABLE' queries to get table lists.
    The query may fail for some reasons (e.g. null .frm file) then
    mysqlcheck doesn't process the database tables.
    
    Fix: try to run 'SHOW TABLES' if 'SHOW FULL TABLES' failed.
    
    
    client/mysqlcheck.c:
      Fix for bug#37527: mysqlcheck fails to report entire database 
      when InnoDB frm file corruption
        - run "SHOW TABLES" query if "SHOW /*!50002 FULL*/ TABLES" failed;
        - print error info if both failed.
    mysql-test/r/mysqlcheck.result:
      Fix for bug#37527: mysqlcheck fails to report entire database 
      when InnoDB frm file corruption
        - test result.
    mysql-test/t/mysqlcheck.test:
      Fix for bug#37527: mysqlcheck fails to report entire database 
      when InnoDB frm file corruption
        - test case.
    e3de8d36
mysqlcheck.c 23.9 KB