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