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
• Status: Can't repeat
• Category: MySQL Server: MyISAM storage engine
• Severity: S1 (Critical)
• Version: Ver 12.22 Distrib 4.0.20
• OS: pc-linux (i686)
• CPU Architecture: Any

[12 Jul 2004 13:16] xuefer tinys

Description:
note the format of the test: "abcd cdef efgh"

both alter table and repair table produce same result
u can do as many times as u want.

default_charset=gbk

How to repeat:
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(10) unsigned NOT NULL default '0',
  `txt` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `txt` (`txt`)
) TYPE=MyISAM;

INSERT INTO `test` VALUES (1, 'abcd cdef efgh');
repair table test;
-- got warnning: Number of rows changed from 1 to 0
repair table test;
-- got warnning: Number of rows changed from 0 to 1

[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