Bug #59057 CHECK FOR UPGRADE for InnoDB tables
Submitted: 20 Dec 2010 12:05
Reporter: Andrii Nikitin Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.1, 5.5 OS:Any
Assigned to: CPU Architecture:Any

[20 Dec 2010 12:05] Andrii Nikitin
Description:
InnoDB currently ignores all CHECK TABLE options.
But there is no need to perform full data and index checks during upgrade, especially if table rebuild is required (e.g. because of index incompatibilities).

So please implement CHECK TABLE ... FOR UPGRADE - so it does look only for table incompatibilities. This will save much time for upgrading InnoDB tables.

How to repeat:
see source code, showing that check_opt parameter is ignored:

ha_innobase::check(
/*===============*/
	THD*		thd,		/*!< in: user thread handle */
	HA_CHECK_OPT*	check_opt)	/*!< in: check options, currently
					ignored */

Suggested fix:
Perform only check for version incompatibilities.
[15 May 2015 5:45] MySQL Verification Team
What exactly is not implemented here;   Can we get a specific case? 

The FOR UPGRADE part is dealt with in the handler at the moment, above the innodb engine.

Search the code for where HA_ADMIN_NEEDS_UPGRADE and HA_ADMIN_NEEDS_ALTER are returned.