show_check.test 1.84 KB
Newer Older
1 2 3
#
# Test of some show commands
#
4
drop table if exists t1,t2;
5 6 7 8 9 10 11 12 13
create table t1 (a int not null primary key, b int not null,c int not null, key(b,c));
insert into t1 values (1,2,2),(2,2,3),(3,2,4),(4,2,4);
create table t2 type=isam select * from t1;
optimize table t1;
check table t1,t2;
repair table t1,t2;
check table t2,t1;
lock tables t1 read;
check table t2,t1;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
14 15
show columns from t1;
show full columns from t1;
16
show index from t1;
17 18 19 20 21 22 23 24 25
drop table t1,t2;

create table t1 (a int not null primary key, b int not null,c int not null, key(b,c));
insert into t1 values (1,2,2),(2,2,3),(3,2,4),(4,2,4);
check table t1 type=fast;
check table t1 type=fast;
check table t1 type=changed;
insert into t1 values (5,5,5);
check table t1 type=changed;
26
check table t1 type=medium;
27
check table t1 type=extended;
28
show index from t1;
29 30 31 32
!$1062 insert into t1 values (5,5,5);
optimize table t1;
optimize table t1;
drop table t1;
33 34 35 36 37 38 39

#show variables;
show variables like "wait_timeout%";
show variables like "this_doesn't_exists%";
show table status from test like "this_doesn't_exists%";
show databases;
show databases like "test%";
40 41 42 43 44 45 46 47 48 49 50

#
# Check of show index
#
create table t1 (f1 int not null, f2 int not null, f3 int not null, f4 int not null, primary key(f1,f2,f3,f4));
insert into t1 values (1,1,1,0),(1,1,2,0),(1,1,3,0),(1,2,1,0),(1,2,2,0),(1,2,3,0),(1,3,1,0),(1,3,2,0),(1,3,3,0),(1,1,1,1),(1,1,2,1),(1,1,3,1),(1,2,1,1),(1,2,2,1),(1,2,3,1),(1,3,1,1),(1,3,2,1),(1,3,3,1);
analyze table t1;
show index from t1;
repair table t1;
show index from t1;
drop table t1;
51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67

#
# Test of SHOW CREATE
#

create temporary table t1 (a int not null);
show create table t1;
alter table t1 rename t2;
show create table t2;
drop table t2;

create table t1 (
  test_set set( 'val1', 'val2', 'val3' ) not null default '',
  name char(20) default 'O''Brien'
  ) comment = 'it\'s a table' ;
show create table t1 ;
drop table t1;