Bug #8841 CHECKSUM TABLE is broken in MyISAM

Submitted: 28 Feb 2005 12:12 Modified: 18 Jun 2010 2:11
Reporter: Sergei Golubchik Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Ingo Strüwing CPU Architecture:Any

[28 Feb 2005 12: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 13: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 13:27] Ingo Strüwing
I doubt that I can get at it in the near future unless its priority is raised.
[1 Feb 2006 15: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 18:38] Ingo Strüwing
Pushed to 5.0.19 and 5.1.7. Description in the changeset.
[22 Feb 2006 18: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>
[5 May 2010 15:06] Bugs System
Pushed into 5.1.47 (revid:joro@sun.com-20100505145753-ivlt4hclbrjy8eye) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[6 May 2010 1:25] Paul DuBois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug. Re-closing.
[28 May 2010 5:58] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (pib:16)
[28 May 2010 6:26] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 6:54] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[30 May 2010 0:24] Paul DuBois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[17 Jun 2010 12:00] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:41] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:27] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.065 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.