> -----Message d'origine----- > De : Richard S. Huntrods [mailto:[EMAIL PROTECTED] > Envoyé : Saturday, January 03, 2004 6:05 PM > À : [EMAIL PROTECTED] > Objet : BUG IN MYSQL > > > I've submitted this problem three times now, and been ignored > all three > times.
http://bugs.mysql.com/ > I guess bugs are simply not popular. Since the problem > described > below is 100% repeatable, I will now escallate it from "problem with > delete/insert" to "BUG IN MYSQL". > > Cheers... > > I've distilled the problem I'm having with DELETE/INSERT to an even > simpler test case. > > Here's the SQL - it can be used with any database, not just > the special > "expdb" I created. I run this script followed by running "mysqlcheck > expdb". > > ######################################### > USE expdb; > > DROP TABLE IF EXISTS appraised; > CREATE TABLE appraised ( > idNumber int(11) NOT NULL default '0', > indexNo int(11) NOT NULL default '0', > experience int(11) default NULL, > lastused int(11) default NULL, > competence int(11) default NULL, > status int(11) default NULL, > appraiser int(11) default NULL, > comments text, > PRIMARY KEY (idNumber,indexNo) > ) TYPE=MyISAM; > > PRINT; > DELETE FROM appraised; > INSERT INTO appraised VALUES (1,1,1,1,1,1,1,'aaa1'); > SELECT * FROM appraised; > DELETE FROM appraised; > ######################################### > > If you run this with the INSERT commented out, mysqlcheck > reports OK. If > you don't comment out the INSERT, mysqlcheck reports: > > C:\mysql-4.0.15\bin>mysqlcheck expdb > expdb.appraised > warning : Table is marked as crashed > warning : Size of indexfile is: 2048 Should be: 1024 > warning : Size of datafile is: 160 Should be: 0 > error : Record-count is not ok; is 4 Should be: 0 > warning : Found 4 parts Should be: 0 parts > error : Corrupt > > This happens every single time. You cannot use the > -autorepair function, > as it reports "appraised.MYD" cannot be opened. > > What is going on? > > Thanks, > > -Richard > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
