1
--- check_table.result 2013-01-22 22:05:05.246633000 +0400
2
+++ check_table.reject 2013-01-23 03:16:23.872340482 +0400
4
DROP TABLE IF EXISTS t1, t2;
5
CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
6
-INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(2,'d'),(4,'e'),(100,'f'),(101,'g');
7
-CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY RANGE(a) (
8
-PARTITION p0 VALUES LESS THAN (100),
9
-PARTITION p1 VALUES LESS THAN MAXVALUE
11
-INSERT INTO t2 (a,b) SELECT a, b FROM t1;
12
-ALTER TABLE t1 CHECK PARTITION p0;
13
-Table Op Msg_type Msg_text
14
-test.t1 check status OK
15
-INSERT INTO t1 (a,b) VALUES (3,'c');
16
-ALTER TABLE t1 CHECK PARTITION p0, p1 FOR UPGRADE;
17
-Table Op Msg_type Msg_text
18
-test.t1 check status OK
19
-INSERT INTO t2 (a,b) VALUES (10000,'e');
20
-ALTER TABLE t2 CHECK PARTITION p0 QUICK;
21
-Table Op Msg_type Msg_text
22
-test.t2 check status OK
23
-INSERT INTO t1 (a,b) VALUES (6,'f');
24
-ALTER TABLE t1 CHECK PARTITION p1 FAST;
25
-Table Op Msg_type Msg_text
26
-test.t1 check status OK
27
-INSERT INTO t2 (a,b) VALUES (8,'h');
28
-ALTER TABLE t2 CHECK PARTITION p1 MEDIUM;
29
-Table Op Msg_type Msg_text
30
-test.t2 check status OK
31
-INSERT INTO t1 (a,b) VALUES (9,'i');
32
-ALTER TABLE t1 CHECK PARTITION ALL EXTENDED;
33
-Table Op Msg_type Msg_text
34
-test.t1 check status OK
35
-INSERT INTO t1 (a,b) VALUES (11,'k');
36
-ALTER TABLE t1 CHECK PARTITION p0 CHANGED;
37
-Table Op Msg_type Msg_text
38
-test.t1 check status OK
40
+ERROR HY000: Engine cannot be used in partitioned tables
41
+# ERROR: Statement ended with errno 1572, errname ER_PARTITION_MERGE_ERROR (expected to succeed)
42
+# ------------ UNEXPECTED RESULT ------------
43
+# [ CREATE TABLE t1 (a INT(11) /*!*/ /*Custom column options*/, b CHAR(8) /*!*/ /*Custom column options*/) ENGINE=MRG_MYISAM /*!*/ /*Custom table options*/ UNION(mrg.t1) INSERT_METHOD=LAST PARTITION BY HASH(a) PARTITIONS 2 ]
44
+# The statement|command finished with ER_PARTITION_MERGE_ERROR.
45
+# Partitions or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors.
46
+# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def.
47
+# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped.
48
+# Also, this problem may cause a chain effect (more errors of different kinds in the test).
49
+# -------------------------------------------
50
DROP TABLE IF EXISTS t1,t2;
51
CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
52
+ERROR HY000: Engine cannot be used in partitioned tables
53
+# ERROR: Statement ended with errno 1572, errname ER_PARTITION_MERGE_ERROR (expected to succeed)
54
INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
55
+ERROR 42S02: Table 'test.t1' doesn't exist
56
CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
57
+ERROR HY000: Engine cannot be used in partitioned tables
58
+# ERROR: Statement ended with errno 1572, errname ER_PARTITION_MERGE_ERROR (expected to succeed)
60
Table Op Msg_type Msg_text
61
-test.t1 check status OK
62
+test.t1 check Error Table 'test.t1' doesn't exist
63
+test.t1 check status Operation failed
64
INSERT INTO t1 (a,b) VALUES (3,'c');
65
+ERROR 42S02: Table 'test.t1' doesn't exist
66
INSERT INTO t2 (a,b) VALUES (4,'d');
67
+ERROR 42S02: Table 'test.t2' doesn't exist
68
CHECK TABLE t1, t2 FOR UPGRADE;
69
Table Op Msg_type Msg_text
70
-test.t1 check status OK
71
-test.t2 check status OK
72
+test.t1 check Error Table 'test.t1' doesn't exist
73
+test.t1 check status Operation failed
74
+test.t2 check Error Table 'test.t2' doesn't exist
75
+test.t2 check status Operation failed
76
INSERT INTO t2 (a,b) VALUES (5,'e');
77
+ERROR 42S02: Table 'test.t2' doesn't exist
79
Table Op Msg_type Msg_text
80
-test.t2 check status OK
81
+test.t2 check Error Table 'test.t2' doesn't exist
82
+test.t2 check status Operation failed
83
INSERT INTO t1 (a,b) VALUES (6,'f');
84
+ERROR 42S02: Table 'test.t1' doesn't exist
86
Table Op Msg_type Msg_text
87
-test.t1 check status OK
88
+test.t1 check Error Table 'test.t1' doesn't exist
89
+test.t1 check status Operation failed
90
INSERT INTO t1 (a,b) VALUES (7,'g');
91
+ERROR 42S02: Table 'test.t1' doesn't exist
92
INSERT INTO t2 (a,b) VALUES (8,'h');
93
+ERROR 42S02: Table 'test.t2' doesn't exist
94
CHECK TABLE t2, t1 MEDIUM;
95
Table Op Msg_type Msg_text
96
-test.t2 check status OK
97
-test.t1 check status OK
98
+test.t2 check Error Table 'test.t2' doesn't exist
99
+test.t2 check status Operation failed
100
+test.t1 check Error Table 'test.t1' doesn't exist
101
+test.t1 check status Operation failed
102
INSERT INTO t1 (a,b) VALUES (9,'i');
103
+ERROR 42S02: Table 'test.t1' doesn't exist
104
INSERT INTO t2 (a,b) VALUES (10,'j');
105
+ERROR 42S02: Table 'test.t2' doesn't exist
106
CHECK TABLE t1, t2 EXTENDED;
107
Table Op Msg_type Msg_text
108
-test.t1 check status OK
109
-test.t2 check status OK
110
+test.t1 check Error Table 'test.t1' doesn't exist
111
+test.t1 check status Operation failed
112
+test.t2 check Error Table 'test.t2' doesn't exist
113
+test.t2 check status Operation failed
114
INSERT INTO t1 (a,b) VALUES (11,'k');
115
+ERROR 42S02: Table 'test.t1' doesn't exist
116
CHECK TABLE t1 CHANGED;
117
Table Op Msg_type Msg_text
118
-test.t1 check status OK
119
+test.t1 check Error Table 'test.t1' doesn't exist
120
+test.t1 check status Operation failed
122
+ERROR 42S02: Unknown table 't1,t2'
123
CREATE TABLE t1 (a <INT_COLUMN>, <CUSTOM_INDEX>(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> PARTITION BY HASH(a) PARTITIONS 2;
124
+ERROR HY000: Engine cannot be used in partitioned tables
125
+# ERROR: Statement ended with errno 1572, errname ER_PARTITION_MERGE_ERROR (expected to succeed)
126
INSERT INTO t1 (a) VALUES (1),(2),(5);
127
+ERROR 42S02: Table 'test.t1' doesn't exist
129
Table Op Msg_type Msg_text
130
-test.t1 check status OK
131
+test.t1 check Error Table 'test.t1' doesn't exist
132
+test.t1 check status Operation failed
133
INSERT INTO t1 (a) VALUES (6),(8),(12);
134
+ERROR 42S02: Table 'test.t1' doesn't exist
135
CHECK TABLE t1 FOR UPGRADE;
136
Table Op Msg_type Msg_text
137
-test.t1 check status OK
138
+test.t1 check Error Table 'test.t1' doesn't exist
139
+test.t1 check status Operation failed
140
INSERT INTO t1 (a) VALUES (13),(15),(16);
141
+ERROR 42S02: Table 'test.t1' doesn't exist
142
CHECK TABLE t1 QUICK;
143
Table Op Msg_type Msg_text
144
-test.t1 check status OK
145
+test.t1 check Error Table 'test.t1' doesn't exist
146
+test.t1 check status Operation failed
147
INSERT INTO t1 (a) VALUES (17),(120),(132);
148
+ERROR 42S02: Table 'test.t1' doesn't exist
150
Table Op Msg_type Msg_text
151
-test.t1 check status OK
152
+test.t1 check Error Table 'test.t1' doesn't exist
153
+test.t1 check status Operation failed
154
INSERT INTO t1 (a) VALUES (801),(900),(7714);
155
+ERROR 42S02: Table 'test.t1' doesn't exist
156
CHECK TABLE t1 MEDIUM;
157
Table Op Msg_type Msg_text
158
-test.t1 check status OK
159
+test.t1 check Error Table 'test.t1' doesn't exist
160
+test.t1 check status Operation failed
161
INSERT INTO t1 (a) VALUES (8760),(10023),(12000);
162
+ERROR 42S02: Table 'test.t1' doesn't exist
163
CHECK TABLE t1 EXTENDED;
164
Table Op Msg_type Msg_text
165
-test.t1 check status OK
166
+test.t1 check Error Table 'test.t1' doesn't exist
167
+test.t1 check status Operation failed
168
INSERT INTO t1 (a) VALUES (13345),(24456),(78302),(143028);
169
+ERROR 42S02: Table 'test.t1' doesn't exist
170
CHECK TABLE t1 CHANGED;
171
Table Op Msg_type Msg_text
172
-test.t1 check status OK
173
+test.t1 check Error Table 'test.t1' doesn't exist
174
+test.t1 check status Operation failed
176
+ERROR 42S02: Unknown table 't1'