1
drop table if exists t1,t2;
2
drop view if exists v1;
3
create table t1(n int not null, key(n), key(n), key(n), key(n));
4
check table t1 extended;
5
insert into t1 values (200000);
6
Table Op Msg_type Msg_text
7
test.t1 check status OK
9
Create table t1(f1 int);
10
Create table t2(f1 int);
11
Create view v1 as Select * from t1;
13
Table Op Msg_type Msg_text
14
test.v1 check status OK
15
test.t2 check status OK
18
CREATE TEMPORARY TABLE t1(a INT);
20
Table Op Msg_type Msg_text
21
test.t1 check status OK
23
Table Op Msg_type Msg_text
24
test.t1 repair status OK
27
# Bug#56422 CHECK TABLE run when the table is locked reports corruption
30
DROP TABLE IF EXISTS t1;
31
CREATE TABLE t1(a INT);
34
SET lock_wait_timeout= 1;
36
Table Op Msg_type Msg_text
37
test.t1 check Error Lock wait timeout exceeded; try restarting transaction
38
test.t1 check status Operation failed