Bug #86744 Docs on CHECKSUM TABLE incomplete
Submitted: 19 Jun 2017 14:41 Modified: 26 Jul 2017 22:38
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6.x probably any OS:Any
Assigned to: CPU Architecture:Any

[19 Jun 2017 14:41] Peter Laursen
Description:
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html

.. does not eplain results below with an InnoDB table (that does not change). 

How to repeat:
SELECT VERSION() -- 5.6.34-log.

CREATE TABLE `faq_faqcaptcha` (
  `id` VARCHAR(6) NOT NULL DEFAULT '',
  `useragent` VARCHAR(255) NOT NULL DEFAULT '',
  `language` CHAR(2) NOT NULL DEFAULT '',
  `ip` VARCHAR(64) NOT NULL DEFAULT '',
  `captcha_time` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=latin1

CHECKSUM TABLE `faq_faqcaptcha`; -- returns checksum
CHECKSUM TABLE `faq_faqcaptcha` EXTENDED; -- returns checksum
CHECKSUM TABLE `faq_faqcaptcha` QUICK; -- NULL
SHOW WARNINGS; -- empty set

Suggested fix:
Document expected behavior of QUICK and EXTENDED keywords with other storage engines than MyISAM.

Why is no warning after NULL returned, BTW? I this more than a docs bug?
[20 Jun 2017 9:16] MySQL Verification Team
Hello Peter,

Thank you for the report.

Thanks,
Umesh
[26 Jul 2017 22:38] Daniel Price
Posted by developer:
 
The CHECKSUM TABLE documentation was updated to state explicitly that the QUICK method is not supported with InnoDB tables.
https://dev.mysql.com/doc/refman/5.6/en/checksum-table.html

The change should appear online soon.

Thank you for the bug report.