Bug #14889 DELETE query consistently causes Index corruption
Submitted: 12 Nov 2005 1:44 Modified: 14 Feb 2006 16:13
Reporter: Matthew Lord Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S1 (Critical)
Version:4.1.15 OS:Windows (Windows 2003 (x86), FC4 (x86))
Assigned to: Evgeny Potemkin CPU Architecture:Any

[12 Nov 2005 1:44] Matthew Lord 
Description:
a delete query corrupts the indexes for this myisam table every time.

How to repeat:
on shell.mysql.com:
install 4.1.15 or 4.1.16-bk 
./bin/mysqld --no-defaults --basedir=. --datadir=/nfstmp1/mattlord/7102/MYSQL-DATA --skip-grant-tables --skip-innodb &
./bin/mysql SIP

SET @Retencion = 60;
SET @FechaLimite = UNIX_TIMESTAMP() - @Retencion * 24 * 3600;
DELETE FROM `external_userattribs` WHERE `DT` < FROM_UNIXTIME(@FechaLimite);

The table files can be found in /nfstmp1/mattlord/7102.tar.gz
[14 Feb 2006 16:13] Evgeny Potemkin 
Can't repeat, tested on 4.1.19.