diff options
| author | unknown <serg@serg.mylan> | 2004-04-07 16:04:28 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-04-07 16:04:28 +0200 |
| commit | 736853e501181c33e692653d00d7a84c6ff68f25 (patch) | |
| tree | 468a8a5c24e34ef26c95a8deb8a952e75ddb5ca1 /mysql-test/r/repair.result | |
| parent | c62705434021f8ed7b7cfdf9dbba5b1751ebd6f2 (diff) | |
| download | mariadb-git-736853e501181c33e692653d00d7a84c6ff68f25.tar.gz | |
post-review fixes
HA_EXTRA_WRITE_CACHE now part of start_bulk_insert()
test cleanups
BitKeeper/deleted/.del-repair_part2-master.sh~f44a8c15d6c36585:
Delete: mysql-test/t/repair_part2-master.sh
BitKeeper/deleted/.del-repair_part2.test~c20f60783b04d001:
Delete: mysql-test/t/repair_part2.test
BitKeeper/deleted/.del-repair_part2.result~72ca166fb248b566:
Delete: mysql-test/r/repair_part2.result
mysql-test/r/myisam.result:
updated
mysql-test/t/lowercase_table2.test:
typo fixed
mysql-test/r/repair.result:
single repair.test from repair_part[12].test
mysql-test/t/lowercase_table3.test:
typo fixed
mysql-test/t/lowercase_table_qcache.test:
newline added
mysql-test/t/myisam.test:
updated
mysql-test/t/repair.test:
single repair.test from repair_part[12].test
sql/field.cc:
reverted
sql/field.h:
style fix
sql/ha_myisam.cc:
add HA_EXTRA_WRITE_CACHE to start_bulk_insert
sql/sql_insert.cc:
add HA_EXTRA_WRITE_CACHE to start_bulk_insert
sql/sql_load.cc:
add HA_EXTRA_WRITE_CACHE to start_bulk_insert
sql/sql_table.cc:
add HA_EXTRA_WRITE_CACHE to start_bulk_insert
Diffstat (limited to 'mysql-test/r/repair.result')
| -rw-r--r-- | mysql-test/r/repair.result | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/r/repair.result b/mysql-test/r/repair.result new file mode 100644 index 00000000000..2398e13b8e3 --- /dev/null +++ b/mysql-test/r/repair.result @@ -0,0 +1,38 @@ +drop table if exists t1; +create table t1 SELECT 1,"table 1"; +repair table t1 use_frm; +Table Op Msg_type Msg_text +test.t1 repair warning Number of rows changed from 0 to 1 +test.t1 repair status OK +alter table t1 ENGINE=HEAP; +repair table t1 use_frm; +Table Op Msg_type Msg_text +test.t1 repair error The storage engine for the table doesn't support repair +drop table t1; +create table t1(id int PRIMARY KEY, st varchar(10), KEY st_key(st)); +insert into t1 values(1, "One"); +alter table t1 disable keys; +show keys from t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 id A 1 NULL NULL BTREE +t1 1 st_key 1 st A NULL NULL NULL YES BTREE disabled +repair table t1 extended; +Table Op Msg_type Msg_text +test.t1 repair status OK +show keys from t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 id A 1 NULL NULL BTREE +t1 1 st_key 1 st A NULL NULL NULL YES BTREE disabled +drop table t1; +repair table t1 use_frm; +Table Op Msg_type Msg_text +test.t1 repair error Table 'test.t1' doesn't exist +create table t1 engine=myisam SELECT 1,"table 1"; +repair table t1; +Table Op Msg_type Msg_text +test.t1 repair error Can't open file: 't1.MYI' (errno: 130) +repair table t1 use_frm; +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; |