Debian Codegraph @

mysql-test/suite/group_replication/r/gr_runtime_verifications.result

raw
1 include/start_and_bootstrap_group_replication.inc
2 SET SESSION sql_log_bin= 0;
3 call mtr.add_suppression("Table .* does not use the InnoDB storage engine. This is not compatible with Group Replication.");
4 SET SESSION sql_log_bin= 1;
5 CREATE TABLE t1 (c1 char(50)) ENGINE=InnoDB;
6 CREATE TABLE t2 (c1 char(50) NOT NULL PRIMARY KEY) ENGINE=MyISAM;
7 CREATE TABLE t3 (c1 char(50)) ENGINE=MyISAM;
8 CREATE TABLE t4 (c1 char(50) NOT NULL PRIMARY KEY) ENGINE=Blackhole;
9 CREATE TABLE tn (cn char(50) NOT NULL PRIMARY KEY) ENGINE=InnoDB;
10 CREATE TABLE t5 (c1 char(50) NOT NULL PRIMARY KEY, FOREIGN KEY (c1) REFERENCES tn(cn) ON UPDATE CASCADE) ENGINE = InnoDB;
11 CREATE TABLE t6 (c1 char(50) NOT NULL PRIMARY KEY, FOREIGN KEY (c1) REFERENCES
12 tn(cn) ON UPDATE CASCADE ON DELETE RESTRICT) ENGINE = InnoDB;
13 CREATE TABLE t7 (c1 char(50) NOT NULL PRIMARY KEY, FOREIGN KEY (c1) REFERENCES tn(cn) ON DELETE CASCADE) ENGINE = InnoDB;
14 CREATE TABLE t8 (c1 char(50) NOT NULL PRIMARY KEY, FOREIGN KEY (c1) REFERENCES
15 tn(cn) ON DELETE CASCADE ON UPDATE RESTRICT) ENGINE = InnoDB;
16 CREATE TABLE t9 (c1 char(50), c2 char(50) NOT NULL PRIMARY KEY, FOREIGN KEY (c1) REFERENCES
17 tn(cn) ON DELETE SET NULL) ENGINE = InnoDB;
18 CREATE TABLE t10 (c1 char(50), c2 char(50) NOT NULL PRIMARY KEY, FOREIGN KEY (c1) REFERENCES
19 tn(cn) ON UPDATE SET NULL) ENGINE = InnoDB;
20 #
21 # Testing all tables that will fail.
22 #
23 INSERT INTO t10 VALUES('a','a');
24 ERROR HY000: The table does not comply with the requirements by an external plugin.
25 UPDATE t10 SET c1 = 'a';
26 ERROR HY000: The table does not comply with the requirements by an external plugin.
27 UPDATE t10 SET c1 = 'a';
28 ERROR HY000: The table does not comply with the requirements by an external plugin.
29 INSERT INTO t10 (c1,c2) SELECT tn.cn,'a' FROM tn;
30 ERROR HY000: The table does not comply with the requirements by an external plugin.
31 DELETE FROM t10;
32 ERROR HY000: The table does not comply with the requirements by an external plugin.
33 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t10;
34 ERROR HY000: The table does not comply with the requirements by an external plugin.
35 REPLACE INTO t10(c1) VALUES('a');
36 ERROR HY000: The table does not comply with the requirements by an external plugin.
37 REPLACE INTO t10 (c1) SELECT tn.cn FROM tn;
38 ERROR HY000: The table does not comply with the requirements by an external plugin.
39 DELETE t10, tn FROM t10, tn;
40 ERROR HY000: The table does not comply with the requirements by an external plugin.
41 UPDATE t10, tn SET c1 = 'a';
42 ERROR HY000: The table does not comply with the requirements by an external plugin.
43 DROP TABLE t10;
44 INSERT INTO t9 VALUES('a','a');
45 ERROR HY000: The table does not comply with the requirements by an external plugin.
46 UPDATE t9 SET c1 = 'a';
47 ERROR HY000: The table does not comply with the requirements by an external plugin.
48 UPDATE t9 SET c1 = 'a';
49 ERROR HY000: The table does not comply with the requirements by an external plugin.
50 INSERT INTO t9 (c1,c2) SELECT tn.cn,'a' FROM tn;
51 ERROR HY000: The table does not comply with the requirements by an external plugin.
52 DELETE FROM t9;
53 ERROR HY000: The table does not comply with the requirements by an external plugin.
54 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t9;
55 ERROR HY000: The table does not comply with the requirements by an external plugin.
56 REPLACE INTO t9(c1) VALUES('a');
57 ERROR HY000: The table does not comply with the requirements by an external plugin.
58 REPLACE INTO t9 (c1) SELECT tn.cn FROM tn;
59 ERROR HY000: The table does not comply with the requirements by an external plugin.
60 DELETE t9, tn FROM t9, tn;
61 ERROR HY000: The table does not comply with the requirements by an external plugin.
62 UPDATE t9, tn SET c1 = 'a';
63 ERROR HY000: The table does not comply with the requirements by an external plugin.
64 DROP TABLE t9;
65 INSERT INTO t8 VALUES('a');
66 ERROR HY000: The table does not comply with the requirements by an external plugin.
67 UPDATE t8 SET c1 = 'a';
68 ERROR HY000: The table does not comply with the requirements by an external plugin.
69 UPDATE t8 SET c1 = 'a';
70 ERROR HY000: The table does not comply with the requirements by an external plugin.
71 INSERT INTO t8 (c1) SELECT tn.cn FROM tn;
72 ERROR HY000: The table does not comply with the requirements by an external plugin.
73 DELETE FROM t8;
74 ERROR HY000: The table does not comply with the requirements by an external plugin.
75 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t8;
76 ERROR HY000: The table does not comply with the requirements by an external plugin.
77 REPLACE INTO t8(c1) VALUES('a');
78 ERROR HY000: The table does not comply with the requirements by an external plugin.
79 REPLACE INTO t8 (c1) SELECT tn.cn FROM tn;
80 ERROR HY000: The table does not comply with the requirements by an external plugin.
81 DELETE t8, tn FROM t8, tn;
82 ERROR HY000: The table does not comply with the requirements by an external plugin.
83 UPDATE t8, tn SET c1 = 'a';
84 ERROR HY000: The table does not comply with the requirements by an external plugin.
85 DROP TABLE t8;
86 INSERT INTO t7 VALUES('a');
87 ERROR HY000: The table does not comply with the requirements by an external plugin.
88 UPDATE t7 SET c1 = 'a';
89 ERROR HY000: The table does not comply with the requirements by an external plugin.
90 UPDATE t7 SET c1 = 'a';
91 ERROR HY000: The table does not comply with the requirements by an external plugin.
92 INSERT INTO t7 (c1) SELECT tn.cn FROM tn;
93 ERROR HY000: The table does not comply with the requirements by an external plugin.
94 DELETE FROM t7;
95 ERROR HY000: The table does not comply with the requirements by an external plugin.
96 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t7;
97 ERROR HY000: The table does not comply with the requirements by an external plugin.
98 REPLACE INTO t7(c1) VALUES('a');
99 ERROR HY000: The table does not comply with the requirements by an external plugin.
100 REPLACE INTO t7 (c1) SELECT tn.cn FROM tn;
101 ERROR HY000: The table does not comply with the requirements by an external plugin.
102 DELETE t7, tn FROM t7, tn;
103 ERROR HY000: The table does not comply with the requirements by an external plugin.
104 UPDATE t7, tn SET c1 = 'a';
105 ERROR HY000: The table does not comply with the requirements by an external plugin.
106 DROP TABLE t7;
107 INSERT INTO t6 VALUES('a');
108 ERROR HY000: The table does not comply with the requirements by an external plugin.
109 UPDATE t6 SET c1 = 'a';
110 ERROR HY000: The table does not comply with the requirements by an external plugin.
111 UPDATE t6 SET c1 = 'a';
112 ERROR HY000: The table does not comply with the requirements by an external plugin.
113 INSERT INTO t6 (c1) SELECT tn.cn FROM tn;
114 ERROR HY000: The table does not comply with the requirements by an external plugin.
115 DELETE FROM t6;
116 ERROR HY000: The table does not comply with the requirements by an external plugin.
117 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t6;
118 ERROR HY000: The table does not comply with the requirements by an external plugin.
119 REPLACE INTO t6(c1) VALUES('a');
120 ERROR HY000: The table does not comply with the requirements by an external plugin.
121 REPLACE INTO t6 (c1) SELECT tn.cn FROM tn;
122 ERROR HY000: The table does not comply with the requirements by an external plugin.
123 DELETE t6, tn FROM t6, tn;
124 ERROR HY000: The table does not comply with the requirements by an external plugin.
125 UPDATE t6, tn SET c1 = 'a';
126 ERROR HY000: The table does not comply with the requirements by an external plugin.
127 DROP TABLE t6;
128 INSERT INTO t5 VALUES('a');
129 ERROR HY000: The table does not comply with the requirements by an external plugin.
130 UPDATE t5 SET c1 = 'a';
131 ERROR HY000: The table does not comply with the requirements by an external plugin.
132 UPDATE t5 SET c1 = 'a';
133 ERROR HY000: The table does not comply with the requirements by an external plugin.
134 INSERT INTO t5 (c1) SELECT tn.cn FROM tn;
135 ERROR HY000: The table does not comply with the requirements by an external plugin.
136 DELETE FROM t5;
137 ERROR HY000: The table does not comply with the requirements by an external plugin.
138 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t5;
139 ERROR HY000: The table does not comply with the requirements by an external plugin.
140 REPLACE INTO t5(c1) VALUES('a');
141 ERROR HY000: The table does not comply with the requirements by an external plugin.
142 REPLACE INTO t5 (c1) SELECT tn.cn FROM tn;
143 ERROR HY000: The table does not comply with the requirements by an external plugin.
144 DELETE t5, tn FROM t5, tn;
145 ERROR HY000: The table does not comply with the requirements by an external plugin.
146 UPDATE t5, tn SET c1 = 'a';
147 ERROR HY000: The table does not comply with the requirements by an external plugin.
148 DROP TABLE t5;
149 INSERT INTO t4 VALUES('a');
150 ERROR HY000: The table does not comply with the requirements by an external plugin.
151 UPDATE t4 SET c1 = 'a';
152 ERROR HY000: The table does not comply with the requirements by an external plugin.
153 UPDATE t4 SET c1 = 'a';
154 ERROR HY000: The table does not comply with the requirements by an external plugin.
155 INSERT INTO t4 (c1) SELECT tn.cn FROM tn;
156 ERROR HY000: The table does not comply with the requirements by an external plugin.
157 DELETE FROM t4;
158 ERROR HY000: The table does not comply with the requirements by an external plugin.
159 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t4;
160 ERROR HY000: The table does not comply with the requirements by an external plugin.
161 REPLACE INTO t4(c1) VALUES('a');
162 ERROR HY000: The table does not comply with the requirements by an external plugin.
163 REPLACE INTO t4 (c1) SELECT tn.cn FROM tn;
164 ERROR HY000: The table does not comply with the requirements by an external plugin.
165 DELETE t4, tn FROM t4, tn;
166 ERROR HY000: The table does not comply with the requirements by an external plugin.
167 UPDATE t4, tn SET c1 = 'a';
168 ERROR HY000: The table does not comply with the requirements by an external plugin.
169 DROP TABLE t4;
170 INSERT INTO t3 VALUES('a');
171 ERROR HY000: The table does not comply with the requirements by an external plugin.
172 UPDATE t3 SET c1 = 'a';
173 ERROR HY000: The table does not comply with the requirements by an external plugin.
174 UPDATE t3 SET c1 = 'a';
175 ERROR HY000: The table does not comply with the requirements by an external plugin.
176 INSERT INTO t3 (c1) SELECT tn.cn FROM tn;
177 ERROR HY000: The table does not comply with the requirements by an external plugin.
178 DELETE FROM t3;
179 ERROR HY000: The table does not comply with the requirements by an external plugin.
180 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t3;
181 ERROR HY000: The table does not comply with the requirements by an external plugin.
182 REPLACE INTO t3(c1) VALUES('a');
183 ERROR HY000: The table does not comply with the requirements by an external plugin.
184 REPLACE INTO t3 (c1) SELECT tn.cn FROM tn;
185 ERROR HY000: The table does not comply with the requirements by an external plugin.
186 DELETE t3, tn FROM t3, tn;
187 ERROR HY000: The table does not comply with the requirements by an external plugin.
188 UPDATE t3, tn SET c1 = 'a';
189 ERROR HY000: The table does not comply with the requirements by an external plugin.
190 DROP TABLE t3;
191 INSERT INTO t2 VALUES('a');
192 ERROR HY000: The table does not comply with the requirements by an external plugin.
193 UPDATE t2 SET c1 = 'a';
194 ERROR HY000: The table does not comply with the requirements by an external plugin.
195 UPDATE t2 SET c1 = 'a';
196 ERROR HY000: The table does not comply with the requirements by an external plugin.
197 INSERT INTO t2 (c1) SELECT tn.cn FROM tn;
198 ERROR HY000: The table does not comply with the requirements by an external plugin.
199 DELETE FROM t2;
200 ERROR HY000: The table does not comply with the requirements by an external plugin.
201 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t2;
202 ERROR HY000: The table does not comply with the requirements by an external plugin.
203 REPLACE INTO t2(c1) VALUES('a');
204 ERROR HY000: The table does not comply with the requirements by an external plugin.
205 REPLACE INTO t2 (c1) SELECT tn.cn FROM tn;
206 ERROR HY000: The table does not comply with the requirements by an external plugin.
207 DELETE t2, tn FROM t2, tn;
208 ERROR HY000: The table does not comply with the requirements by an external plugin.
209 UPDATE t2, tn SET c1 = 'a';
210 ERROR HY000: The table does not comply with the requirements by an external plugin.
211 DROP TABLE t2;
212 INSERT INTO t1 VALUES('a');
213 ERROR HY000: The table does not comply with the requirements by an external plugin.
214 UPDATE t1 SET c1 = 'a';
215 ERROR HY000: The table does not comply with the requirements by an external plugin.
216 UPDATE t1 SET c1 = 'a';
217 ERROR HY000: The table does not comply with the requirements by an external plugin.
218 INSERT INTO t1 (c1) SELECT tn.cn FROM tn;
219 ERROR HY000: The table does not comply with the requirements by an external plugin.
220 DELETE FROM t1;
221 ERROR HY000: The table does not comply with the requirements by an external plugin.
222 LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE t1;
223 ERROR HY000: The table does not comply with the requirements by an external plugin.
224 REPLACE INTO t1(c1) VALUES('a');
225 ERROR HY000: The table does not comply with the requirements by an external plugin.
226 REPLACE INTO t1 (c1) SELECT tn.cn FROM tn;
227 ERROR HY000: The table does not comply with the requirements by an external plugin.
228 DELETE t1, tn FROM t1, tn;
229 ERROR HY000: The table does not comply with the requirements by an external plugin.
230 UPDATE t1, tn SET c1 = 'a';
231 ERROR HY000: The table does not comply with the requirements by an external plugin.
232 DROP TABLE t1;
233 #
234 # Lets test the global variables that might change in
235 # runtime and which values are not allowed.
236 #
237 SET SESSION binlog_format= STATEMENT;
238 Warnings:
239 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
240 INSERT INTO tn VALUES ('a');
241 ERROR HY000: The table does not comply with the requirements by an external plugin.
242 SET SESSION binlog_format= "ROW";
243 Warnings:
244 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
245 SET SESSION transaction_write_set_extraction=OFF;
246 ERROR HY000: The write set algorithm cannot be changed when Group replication is running.
247 INSERT INTO tn VALUES ('hash');
248 #
249 # Now, lets repeat all the tests with group replication stopped.
250 # They all must succeed or fail with other errors that not the
251 # ones from validation.
252 #
253 # It will be a single table simpler test just to assess that the
254 # hook is not longer active.
255 #
256 include/stop_group_replication.inc
257 CREATE TABLE t1 (c1 char(50)) ENGINE=InnoDB;
258 UPDATE t1 SET c1 = 'a';
259 INSERT INTO t1 VALUES('a');
260 INSERT INTO t1 (c1) SELECT tn.cn FROM tn;
261 DELETE FROM t1;
262 LOAD DATA INFILE '../../std_data/words2.dat' INTO TABLE t1;
263 REPLACE INTO t1(c1) VALUES('a');
264 REPLACE INTO t1 (c1) SELECT tn.cn FROM tn;
265 DELETE t1, tn FROM t1, tn;
266 UPDATE t1, tn SET c1 = 'a';
267 DROP TABLE t1, tn;
268 call mtr.add_suppression("Table.*is not transactional. This is not compatible with Group Replication");
269 call mtr.add_suppression("Table.*does not have any PRIMARY KEY. This is not compatible with Group Replication.");
270 call mtr.add_suppression("Table.*has a foreign key with 'CASCADE', 'SET NULL' or 'SET DEFAULT' clause. This is not compatible with Group Replication.");
271 call mtr.add_suppression("Binlog format should be ROW for Group Replication");
272 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");