Debian Codegraph @

mysql-test/suite/storage_engine/check_table.result

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
3 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
4 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
5 CHECK TABLE t1;
6 Table Op Msg_type Msg_text
7 test.t1 check status OK
8 INSERT INTO t1 (a,b) VALUES (3,'c');
9 INSERT INTO t2 (a,b) VALUES (4,'d');
10 CHECK TABLE t1, t2 FOR UPGRADE;
11 Table Op Msg_type Msg_text
12 test.t1 check status OK
13 test.t2 check status OK
14 INSERT INTO t2 (a,b) VALUES (5,'e');
15 CHECK TABLE t2 QUICK;
16 Table Op Msg_type Msg_text
17 test.t2 check status OK
18 INSERT INTO t1 (a,b) VALUES (6,'f');
19 CHECK TABLE t1 FAST;
20 Table Op Msg_type Msg_text
21 test.t1 check status OK
22 INSERT INTO t1 (a,b) VALUES (7,'g');
23 INSERT INTO t2 (a,b) VALUES (8,'h');
24 CHECK TABLE t2, t1 MEDIUM;
25 Table Op Msg_type Msg_text
26 test.t2 check status OK
27 test.t1 check status OK
28 INSERT INTO t1 (a,b) VALUES (9,'i');
29 INSERT INTO t2 (a,b) VALUES (10,'j');
30 CHECK TABLE t1, t2 EXTENDED;
31 Table Op Msg_type Msg_text
32 test.t1 check status OK
33 test.t2 check status OK
34 INSERT INTO t1 (a,b) VALUES (11,'k');
35 CHECK TABLE t1 CHANGED;
36 Table Op Msg_type Msg_text
37 test.t1 check status OK
38 DROP TABLE t1, t2;
39 CREATE TABLE t1 (a <INT_COLUMN>, <CUSTOM_INDEX>(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
40 INSERT INTO t1 (a) VALUES (1),(2),(5);
41 CHECK TABLE t1;
42 Table Op Msg_type Msg_text
43 test.t1 check status OK
44 INSERT INTO t1 (a) VALUES (6),(8),(12);
45 CHECK TABLE t1 FOR UPGRADE;
46 Table Op Msg_type Msg_text
47 test.t1 check status OK
48 INSERT INTO t1 (a) VALUES (13),(15),(16);
49 CHECK TABLE t1 QUICK;
50 Table Op Msg_type Msg_text
51 test.t1 check status OK
52 INSERT INTO t1 (a) VALUES (17),(120),(132);
53 CHECK TABLE t1 FAST;
54 Table Op Msg_type Msg_text
55 test.t1 check status OK
56 INSERT INTO t1 (a) VALUES (801),(900),(7714);
57 CHECK TABLE t1 MEDIUM;
58 Table Op Msg_type Msg_text
59 test.t1 check status OK
60 INSERT INTO t1 (a) VALUES (8760),(10023),(12000);
61 CHECK TABLE t1 EXTENDED;
62 Table Op Msg_type Msg_text
63 test.t1 check status OK
64 INSERT INTO t1 (a) VALUES (13345),(24456),(78302),(143028);
65 CHECK TABLE t1 CHANGED;
66 Table Op Msg_type Msg_text
67 test.t1 check status OK
68 DROP TABLE t1;