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:
None 
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
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