summaryrefslogtreecommitdiff
path: root/mysql-test/t/repair_part1.test
blob: e82edb6471380ab380f67834b43d7c4b3ea85885 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#
# Test of repair table
#

--disable_warnings
drop table if exists t1;
--enable_warnings

create table t1 SELECT 1,"table 1";
repair table t1 use_frm;
alter table t1 ENGINE=HEAP;
repair table t1 use_frm;
drop table t1;

# non-existent table
repair table t1 use_frm;

#
# Create test table for repair2
# The following must be last in this file

create table t1 engine=myisam SELECT 1,"table 1";