Debian Codegraph @

mysql-test/suite/storage_engine/parts/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> PARTITION BY HASH(a) PARTITIONS 2;
3 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(2,'d'),(4,'e'),(100,'f'),(101,'g');
4 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY RANGE(a) (
5 PARTITION p0 VALUES LESS THAN (100),
6 PARTITION p1 VALUES LESS THAN MAXVALUE
7 );
8 INSERT INTO t2 (a,b) SELECT a, b FROM t1;
9 ALTER TABLE t1 CHECK PARTITION p0;
10 Table Op Msg_type Msg_text
11 test.t1 check status OK
12 INSERT INTO t1 (a,b) VALUES (3,'c');
13 ALTER TABLE t1 CHECK PARTITION p0, p1 FOR UPGRADE;
14 Table Op Msg_type Msg_text
15 test.t1 check status OK
16 INSERT INTO t2 (a,b) VALUES (10000,'e');
17 ALTER TABLE t2 CHECK PARTITION p0 QUICK;
18 Table Op Msg_type Msg_text
19 test.t2 check status OK
20 INSERT INTO t1 (a,b) VALUES (6,'f');
21 ALTER TABLE t1 CHECK PARTITION p1 FAST;
22 Table Op Msg_type Msg_text
23 test.t1 check status OK
24 INSERT INTO t2 (a,b) VALUES (8,'h');
25 ALTER TABLE t2 CHECK PARTITION p1 MEDIUM;
26 Table Op Msg_type Msg_text
27 test.t2 check status OK
28 INSERT INTO t1 (a,b) VALUES (9,'i');
29 ALTER TABLE t1 CHECK PARTITION ALL EXTENDED;
30 Table Op Msg_type Msg_text
31 test.t1 check status OK
32 INSERT INTO t1 (a,b) VALUES (11,'k');
33 ALTER TABLE t1 CHECK PARTITION p0 CHANGED;
34 Table Op Msg_type Msg_text
35 test.t1 check status OK
36 DROP TABLE t1, t2;
37 DROP TABLE IF EXISTS t1,t2;
38 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
39 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
40 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
41 CHECK TABLE t1;
42 Table Op Msg_type Msg_text
43 test.t1 check status OK
44 INSERT INTO t1 (a,b) VALUES (3,'c');
45 INSERT INTO t2 (a,b) VALUES (4,'d');
46 CHECK TABLE t1, t2 FOR UPGRADE;
47 Table Op Msg_type Msg_text
48 test.t1 check status OK
49 test.t2 check status OK
50 INSERT INTO t2 (a,b) VALUES (5,'e');
51 CHECK TABLE t2 QUICK;
52 Table Op Msg_type Msg_text
53 test.t2 check status OK
54 INSERT INTO t1 (a,b) VALUES (6,'f');
55 CHECK TABLE t1 FAST;
56 Table Op Msg_type Msg_text
57 test.t1 check status OK
58 INSERT INTO t1 (a,b) VALUES (7,'g');
59 INSERT INTO t2 (a,b) VALUES (8,'h');
60 CHECK TABLE t2, t1 MEDIUM;
61 Table Op Msg_type Msg_text
62 test.t2 check status OK
63 test.t1 check status OK
64 INSERT INTO t1 (a,b) VALUES (9,'i');
65 INSERT INTO t2 (a,b) VALUES (10,'j');
66 CHECK TABLE t1, t2 EXTENDED;
67 Table Op Msg_type Msg_text
68 test.t1 check status OK
69 test.t2 check status OK
70 INSERT INTO t1 (a,b) VALUES (11,'k');
71 CHECK TABLE t1 CHANGED;
72 Table Op Msg_type Msg_text
73 test.t1 check status OK
74 DROP TABLE t1, t2;
75 CREATE TABLE t1 (a <INT_COLUMN>, <CUSTOM_INDEX>(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
76 INSERT INTO t1 (a) VALUES (1),(2),(5);
77 CHECK TABLE t1;
78 Table Op Msg_type Msg_text
79 test.t1 check status OK
80 INSERT INTO t1 (a) VALUES (6),(8),(12);
81 CHECK TABLE t1 FOR UPGRADE;
82 Table Op Msg_type Msg_text
83 test.t1 check status OK
84 INSERT INTO t1 (a) VALUES (13),(15),(16);
85 CHECK TABLE t1 QUICK;
86 Table Op Msg_type Msg_text
87 test.t1 check status OK
88 INSERT INTO t1 (a) VALUES (17),(120),(132);
89 CHECK TABLE t1 FAST;
90 Table Op Msg_type Msg_text
91 test.t1 check status OK
92 INSERT INTO t1 (a) VALUES (801),(900),(7714);
93 CHECK TABLE t1 MEDIUM;
94 Table Op Msg_type Msg_text
95 test.t1 check status OK
96 INSERT INTO t1 (a) VALUES (8760),(10023),(12000);
97 CHECK TABLE t1 EXTENDED;
98 Table Op Msg_type Msg_text
99 test.t1 check status OK
100 INSERT INTO t1 (a) VALUES (13345),(24456),(78302),(143028);
101 CHECK TABLE t1 CHANGED;
102 Table Op Msg_type Msg_text
103 test.t1 check status OK
104 DROP TABLE t1;