From f238f58769a308bcf74e1e1c12655829c14c50ca Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 28 Jun 2002 15:06:04 +0300 Subject: Fixed bug in REPAIR table. Portability fix in safemalloc.c libmysqld/lib_sql.cc: Removed not needed define myisam/sort.c: Fixed core dump crash in repair table. mysql-test/r/myisam.result: Test for repair table mysql-test/t/myisam.test: Test for repair table mysys/safemalloc.c: Portability fix --- mysql-test/t/myisam.test | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) (limited to 'mysql-test/t') diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index 861bc807323..8a65ffcc72f 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -66,3 +66,30 @@ explain select a,b from t1 order by b; explain select a,b from t1; explain select a,b,c from t1; drop table t1; + +# +# Test of REPAIR that once failed +# +CREATE TABLE `t1` ( + `post_id` mediumint(8) unsigned NOT NULL auto_increment, + `topic_id` mediumint(8) unsigned NOT NULL default '0', + `post_time` datetime NOT NULL default '0000-00-00 00:00:00', + `post_text` text NOT NULL, + `icon_url` varchar(10) NOT NULL default '', + `sign` tinyint(1) unsigned NOT NULL default '0', + `post_edit` varchar(150) NOT NULL default '', + `poster_login` varchar(35) NOT NULL default '', + `ip` varchar(15) NOT NULL default '', + PRIMARY KEY (`post_id`), + KEY `post_time` (`post_time`), + KEY `ip` (`ip`), + KEY `poster_login` (`poster_login`), + KEY `topic_id` (`topic_id`), + FULLTEXT KEY `post_text` (`post_text`) +) TYPE=MyISAM; + +INSERT INTO t1 (post_text) VALUES ('ceci est un test'),('ceci est un test'),('ceci est un test'),('ceci est un test'),('ceci est un test'); + +REPAIR TABLE t1; +drop table t1; + -- cgit v1.2.1