Bug #2420 Fulltext index corrups table

• Submitted: 16 Jan 2004 1:58
• Modified: 18 Jan 2004 7:05
• Reporter: Vaclav Vobornik
• Status: Duplicate
• Category: MySQL Server: MyISAM storage engine
• Severity: S2 (Serious)
• Version: 4.1.2-dev latest
• OS: Linux (Linux 2.4.21)
• Assigned to: Assigned Account
• CPU Architecture: Any

[16 Jan 2004 1:58] Vaclav Vobornik

Description:
I am not able to work with fulltext index. I have to use slow fulltext search
"in boolean mode" without fulltext index :-(( 
Without fulltext index it works fine, when I use fulltext index, table becomes corrupted.

How to repeat:

This sql make table directly corrupted:
http://www.blogator.com/bug/corrupt_mysql_table.zip 

root@linux:~# mysql -D test <items.sql 
root@linux:~# mysql -D test -e "repair table items;"
+------------+--------+----------+----------+
| Table      | Op     | Msg_type | Msg_text |
+------------+--------+----------+----------+
| test.items | repair | status   | OK       |
+------------+--------+----------+----------+

root@linux:~# mysql -D test -e "check table items;"
+------------+-------+----------+--------------------------------------+
| Table      | Op    | Msg_type | Msg_text                             |
+------------+-------+----------+--------------------------------------+
| test.items | check | error    | Key in wrong position at page 451584 |
| test.items | check | error    | Corrupt                              |
+------------+-------+----------+--------------------------------------+

[18 Jan 2004 7:05] Sergei Golubchik

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

duplicate of 2190