[BUG] Table corrupted by specific sequence (4.0.3-beta)

[Martin Mokrejs]

Hi,
  I can confirm this on Linux i386 with official binaries on MyISAM
tables:

mysql> check table blast;
DELETE FROM +----------------+-------+----------+----------+
| Table          | Op    | Msg_type | Msg_text |
+----------------+-------+----------+----------+
| test_mmo.blast | check | status   | OK       |
+----------------+-------+----------+----------+
1 row in set (3.40 sec)

mysql> LOCK TABLES blast write;
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM blast;
Query OK, 69549 rows affected (0.10 sec)

mysql> select count(*) from blast;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.04 sec)

mysql> OPTIMIZE TABLE blast;
+----------------+----------+----------+----------------------------------------+

| Table          | Op       | Msg_type |
Msg_text                               |
+----------------+----------+----------+----------------------------------------+

| test_mmo.blast | optimize | warning  | Number of rows changed from 0
to 69549 |
| test_mmo.blast | optimize | status   |
OK                                     |
+----------------+----------+----------+----------------------------------------+

2 rows in set (0.03 sec)

mysql> select count(*) from blast;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> check table blast;
+----------------+-------+----------+-------------------------------------------------------+

| Table          | Op    | Msg_type |
Msg_text                                              |
+----------------+-------+----------+-------------------------------------------------------+

| test_mmo.blast | check | error    | Size of indexfile is: 1024
Should be: 10120192 |
| test_mmo.blast | check | error    | Size of datafile is: 0
Should be: 92046876    |
| test_mmo.blast | check | error    |
Corrupt                                               |
+----------------+-------+----------+-------------------------------------------------------+

3 rows in set (0.00 sec)

Martin


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php