Bug #23526 show table status reports incorrect values for MyISAM tables
Submitted: 21 Oct 2006 18:45 Modified: 25 Jan 2007 16:21
Reporter: Shane Bester
Status: Closed
Category:Server: MyISAM Severity:S1 (Critical)
Version:5.0.26,5.0BK,5.1BK OS:Linux (suse, windows x86)
Assigned to: Sergey Vojtovich Target Version:
Tags: myisam, show table status, row count, Incorrect Results, bfsm_2006_11_02

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-23526.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[21 Oct 2006 18:46] Shane Bester 
see top of file for compiling instructions.

Attachment: testcase.c (text/x-csrc), 3.78 KiB.
[21 Oct 2006 18:47] Shane Bester 
note the jump from 14541 rows  to 14420 to 14566 to 14420

Attachment: myisam_show_table_status.txt (plain/text, text), 13.48 KiB.
[21 Oct 2006 19:40] Shane Bester 
.

Attachment: another_session_output.txt (plain/text, text), 13.68 KiB.