Bug #4514 | alter table/repair table on a fulltext indexed table get data lost/recover | ||
---|---|---|---|
Submitted: | 12 Jul 2004 13:16 | Modified: | 17 Jul 2004 13:03 |
Reporter: | xuefer tinys | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S1 (Critical) |
Version: | Ver 12.22 Distrib 4.0.20 | OS: | pc-linux (i686) |
Assigned to: | CPU Architecture: | Any |
[12 Jul 2004 13:16]
xuefer tinys
[17 Jul 2004 13:03]
Alexander Keremidarski
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Thank you for your interest in MySQL. Additional info: mysql> show variables like "character_set"; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | character_set | gbk | +---------------+-------+ mysql> INSERT INTO `test` VALUES (1, 'abcd cdef efgh'); Query OK, 1 row affected (0.00 sec) mysql> repair table test; +-----------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-----------+--------+----------+----------+ | bugs.test | repair | status | OK | +-----------+--------+----------+----------+
[17 Jul 2004 16:00]
xuefer tinys
http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-standard-4.0.20-pc-linux-i686-icc.tar.g... for linux, can reproduce the problem, ma and http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.20d-win-noinstall.zip/from/pick for win98 can't