diff options
author | unknown <monty@hundin.mysql.fi> | 2002-06-28 15:06:04 +0300 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2002-06-28 15:06:04 +0300 |
commit | f238f58769a308bcf74e1e1c12655829c14c50ca (patch) | |
tree | 50f891adc2032af8c95592f9869e2a78f3cc778f /mysql-test/r/myisam.result | |
parent | d7a84c7af0e1eb166c48ce7a7c3e3dca83f43baf (diff) | |
download | mariadb-git-f238f58769a308bcf74e1e1c12655829c14c50ca.tar.gz |
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
Diffstat (limited to 'mysql-test/r/myisam.result')
-rw-r--r-- | mysql-test/r/myisam.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index c5c69c1ba7b..ac9665ad906 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -75,3 +75,25 @@ explain select a,b,c from t1; table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 drop table t1; +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; +Table Op Msg_type Msg_text +test.t1 repair status OK +drop table t1; |