I've submitted this problem three times now, and been ignored all three times.
Sorry for this inconvenience but I suggest you in the next time to use the MySQL's forums for to report bugs instead of the general list:
<http://www.mysql.com/doc/en/Bug_reports.html>MySQL Manual | 1.7.1.3 How to Report Bugs<http://www.mysql.com/doc/en/Bug_reports.html> or Problems
http://www.mysql.com/doc/en/Bug_reports.html
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".
I tested with the latest release package 4.0.17 and verify that your reported behavior is already fixed. I guess that this case is the same as reported in the below bug report:
http://bugs.mysql.com/bug.php?id=1397
Follows the results of your test case:
C:\mysql\bin>mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.17-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> DROP TABLE IF EXISTS appraised; Query OK, 0 rows affected (0.12 sec)
mysql> 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;
Query OK, 0 rows affected (0.37 sec)mysql> mysql> mysql> PRINT; -------------- PRINT --------------
mysql> DELETE FROM appraised; Query OK, 0 rows affected (0.01 sec)
mysql> INSERT INTO appraised VALUES (1,1,1,1,1,1,1,'aaa1'); Query OK, 1 row affected (0.01 sec)
mysql> SELECT * FROM appraised;
+----------+---------+------------+----------+------------+--------+-----------+----------+
| idNumber | indexNo | experience | lastused | competence | status | appraiser | comments |
+----------+---------+------------+----------+------------+--------+-----------+----------+
| 1 | 1 | 1 | 1 | 1 | 1 | 1 | aaa1 |
+----------+---------+------------+----------+------------+--------+-----------+----------+
1 row in set (0.00 sec)
mysql> DELETE FROM appraised; Query OK, 1 row affected (0.01 sec)
C:\mysql\bin>mysqlcheck test <cut> test.appraised OK
Thanks you for the bug report.
-- Regards,
For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/
Miguel Angel Solórzano <[EMAIL PROTECTED]> São Paulo - Brazil
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
