Bug #8841 CHECKSUM TABLE is broken in MyISAM
Submitted: 28 Feb 2005 13:12 Modified: 22 Feb 2006 19:43
Reporter: Sergei Golubchik
Status: Closed
Category:Server: MyISAM Severity:S3 (Non-critical)
Version: OS:
Assigned to: Ingo Strüwing Target Version:

[28 Feb 2005 13:12] Sergei Golubchik 
Description:
CHECKSUM TABLE myisam_table

returns different results depending on whether checksum is live or calculated

How to repeat:
see myisam.test

CHECKSUM TABLE t1 QUICK
CHECKSUM TABLE t1 EXTENDED

should return the same number
(actually all CHECKSUM TABLE commands in the test should return
the same number or NULL)
[18 Jan 2006 14:14] Osku Salerma 
Do you have any plans to fix this in the near future? I'm asking because as far as I can
see, I can not work on bug #8552 until this bug is fixed.
[18 Jan 2006 14:27] Ingo Strüwing 
I doubt that I can get at it in the near future unless its priority is raised.
[1 Feb 2006 16:51] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2012
[16 Feb 2006 19:38] Ingo Strüwing 
Pushed to 5.0.19 and 5.1.7. Description in the changeset.
[22 Feb 2006 19:43] Mike Hillyer 
Documented in 5.0.19 and 5.1.7 changelogs:

   <listitem>
        <para>
          <literal>CHECKSUM TABLE</literal> returned different values on
          MyISAM table depending on whether the <literal>QUICK</literal>
          or <literal>EXTENDED</literal> options were used. (Bug #8841)
        </para>
      </listitem>