|
1
by brian
clean slate |
1 |
create table t1 (a bigint); |
2 |
insert into t1 values(0); |
|
3 |
analyze table t1; |
|
4 |
Table Op Msg_type Msg_text |
|
5 |
test.t1 analyze status OK |
|
6 |
check table t1; |
|
7 |
Table Op Msg_type Msg_text |
|
8 |
test.t1 check status OK |
|
9 |
drop table t1; |
|
10 |
create table t1 (a bigint); |
|
11 |
insert into t1 values(0); |
|
12 |
delete from t1; |
|
13 |
analyze table t1; |
|
14 |
Table Op Msg_type Msg_text |
|
15 |
test.t1 analyze status OK |
|
16 |
check table t1; |
|
17 |
Table Op Msg_type Msg_text |
|
18 |
test.t1 check status OK |
|
19 |
drop table t1; |
|
20 |
create table t1 (a bigint); |
|
21 |
insert into t1 values(0); |
|
22 |
analyze table t1; |
|
23 |
Table Op Msg_type Msg_text |
|
24 |
test.t1 analyze status OK |
|
25 |
check table t1; |
|
26 |
Table Op Msg_type Msg_text |
|
27 |
test.t1 check status OK |
|
28 |
drop table t1; |
|
|
1245.3.4
by Stewart Smith
make the equals of KEY=VALUE required for CREATE TABLE options |
29 |
create TEMPORARY table t1 (a varchar(10), key key1(a)) collate=utf8_general_ci engine=myisam; |
|
1
by brian
clean slate |
30 |
insert into t1 values ('hello'); |
31 |
analyze table t1; |
|
32 |
Table Op Msg_type Msg_text |
|
|
1121.1.6
by Brian Aker
Remove bits of MyISAM related to Admin cleanup. |
33 |
test.t1 analyze note The storage engine for the table doesn't support analyze |
|
1
by brian
clean slate |
34 |
analyze table t1; |
35 |
Table Op Msg_type Msg_text |
|
|
1121.1.6
by Brian Aker
Remove bits of MyISAM related to Admin cleanup. |
36 |
test.t1 analyze note The storage engine for the table doesn't support analyze |
|
1
by brian
clean slate |
37 |
drop table t1; |
38 |
create temporary table t1(a int, index(a)); |
|
39 |
insert into t1 values('1'),('2'),('3'),('4'),('5'); |
|
40 |
analyze table t1; |
|
41 |
Table Op Msg_type Msg_text |
|
42 |
test.t1 analyze status OK |
|
|
1273.19.12
by Brian Aker
Enabled more tests. |
43 |
show index from t1; |
|
1309.2.3
by Brian Aker
Update the code so use a faster index lookup method. |
44 |
Table Unique Key_name Seq_in_index Column_name |
|
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
45 |
t1 NO a 1 a |
|
1
by brian
clean slate |
46 |
drop table t1; |
47 |
End of 4.1 tests |
|
48 |
End of 5.0 tests |