summaryrefslogtreecommitdiff
path: root/mysql-test/r/repair.result
diff options
context:
space:
mode:
authorunknown <brian@zim.(none)>2006-08-14 15:24:29 -0700
committerunknown <brian@zim.(none)>2006-08-14 15:24:29 -0700
commit948a89432738e4d3b9c4d2f8287573f97e81ecb3 (patch)
tree2e163bcaefab8eeba55ac25ca6707e3181740da8 /mysql-test/r/repair.result
parent45a5ca85f35d1c13528140b449a27d6b2a47d09d (diff)
parent61d5563ba413c18b2674e97016093c082b9918d0 (diff)
downloadmariadb-git-948a89432738e4d3b9c4d2f8287573f97e81ecb3.tar.gz
Merge zim.(none):/home/brian/mysql/dep-5.0
into zim.(none):/home/brian/mysql/dep-5.1 client/mysql.cc: Auto merged mysql-test/r/grant.result: Auto merged mysql-test/r/grant2.result: Auto merged mysql-test/r/heap_btree.result: Auto merged mysql-test/t/grant.test: Auto merged mysql-test/t/grant2.test: Auto merged mysql-test/t/mysqlbinlog.test: Auto merged mysql-test/t/repair.test: Auto merged scripts/fill_func_tables.sh: Auto merged scripts/mysql_install_db.sh: Auto merged sql/field.cc: Auto merged sql/field.h: Auto merged sql/mysqld.cc: Auto merged sql/set_var.cc: Auto merged sql/sql_update.cc: Auto merged storage/heap/hp_delete.c: Auto merged storage/myisam/mi_update.c: Auto merged storage/myisam/sort.c: Auto merged mysql-test/r/mysqldump.result: Fixing Result mysql-test/r/repair.result: Fixing result mysql-test/t/mysqldump.test: Merging change storage/archive/ha_archive.cc: Merging in change
Diffstat (limited to 'mysql-test/r/repair.result')
-rw-r--r--mysql-test/r/repair.result15
1 files changed, 10 insertions, 5 deletions
diff --git a/mysql-test/r/repair.result b/mysql-test/r/repair.result
index f08dc6a8a4a..9b07281aa7b 100644
--- a/mysql-test/r/repair.result
+++ b/mysql-test/r/repair.result
@@ -41,9 +41,14 @@ Table Op Msg_type Msg_text
test.t1 repair warning Number of rows changed from 0 to 1
test.t1 repair status OK
drop table t1;
-DROP TABLE IF EXISTS tt1;
-CREATE TEMPORARY TABLE tt1 (c1 INT);
-REPAIR TABLE tt1 USE_FRM;
+CREATE TABLE t1(a INT, KEY(a));
+INSERT INTO t1 VALUES(1),(2),(3),(4),(5);
+SET myisam_repair_threads=2;
+REPAIR TABLE t1;
Table Op Msg_type Msg_text
-tt1 repair error Cannot repair temporary table from .frm file
-DROP TABLE tt1;
+test.t1 repair status OK
+SHOW INDEX FROM t1;
+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
+t1 1 a 1 a A 5 NULL NULL YES BTREE
+SET myisam_repair_threads=@@global.myisam_repair_threads;
+DROP TABLE t1;