Debian Codegraph @

mysql-test/suite/galera/t/MDEV-30732.test

raw
1 --source include/galera_cluster.inc
2
3 #
4 # MDEV-30732 : wsrep_store_key_val_for_row() may invoke memcpy() on nullptr
5 # original test case
6 #
7 SET GLOBAL sql_mode=0;
8 SET sql_mode=DEFAULT;
9 CREATE TABLE t (c INT,c2 BLOB NOT NULL,KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
10 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
11 SELECT * from t;
12 DROP TABLE t;
13 #
14 # Additional test cases
15 #
16 CREATE TABLE t (c INT,c2 BLOB NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
17 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
18 UPDATE t SET c2=NULL WHERE c = 1;
19 UPDATE t SET c2="" WHERE c=1;
20 UPDATE t SET c2="TESTtest" WHERE c = 1;
21 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
22 DELETE FROM t WHERE c2="BUGbug";
23 SELECT * from t;
24 DROP TABLE t;
25 CREATE TABLE t (c INT,c2 BLOB NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
26 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
27 UPDATE t SET c2=NULL WHERE c = 1;
28 UPDATE t SET c2="" WHERE c=1;
29 UPDATE t SET c2="TESTtest" WHERE c = 1;
30 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
31 DELETE FROM t WHERE c2="BUGbug";
32 SELECT * from t;
33 DROP TABLE t;
34 CREATE TABLE t (c INT,c2 VARCHAR(270) NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
35 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
36 UPDATE t SET c2=NULL WHERE c = 1;
37 UPDATE t SET c2="" WHERE c=1;
38 UPDATE t SET c2="TESTtest" WHERE c = 1;
39 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
40 DELETE FROM t WHERE c2="BUGbug";
41 SELECT * from t;
42 DROP TABLE t;
43 CREATE TABLE t (c INT,c2 VARCHAR(270) NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
44 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
45 UPDATE t SET c2=NULL WHERE c = 1;
46 UPDATE t SET c2="" WHERE c=1;
47 UPDATE t SET c2="TESTtest" WHERE c = 1;
48 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
49 DELETE FROM t WHERE c2="BUGbug";
50 SELECT * from t;
51 DROP TABLE t;
52 CREATE TABLE t (c INT,c2 CHAR(80) NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
53 UPDATE t SET c2=NULL WHERE c = 1;
54 UPDATE t SET c2="" WHERE c=1;
55 UPDATE t SET c2="TESTtest" WHERE c = 1;
56 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
57 DELETE FROM t WHERE c2="BUGbug";
58 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
59 SELECT * from t;
60 DROP TABLE t;
61 CREATE TABLE t (c INT,c2 CHAR(80) NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
62 UPDATE t SET c2=NULL WHERE c = 1;
63 UPDATE t SET c2="" WHERE c=1;
64 UPDATE t SET c2="TESTtest" WHERE c = 1;
65 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
66 DELETE FROM t WHERE c2="BUGbug";
67 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
68 SELECT * from t;
69 DROP TABLE t;
70 CREATE TABLE t (c INT,c2 TEXT NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
71 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
72 UPDATE t SET c2=NULL WHERE c = 1;
73 UPDATE t SET c2="" WHERE c=1;
74 UPDATE t SET c2="TESTtest" WHERE c = 1;
75 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
76 DELETE FROM t WHERE c2="BUGbug";
77 SELECT * from t;
78 DROP TABLE t;
79 CREATE TABLE t (c INT,c2 TEXT NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
80 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
81 UPDATE t SET c2=NULL WHERE c = 1;
82 UPDATE t SET c2="" WHERE c=1;
83 UPDATE t SET c2="TESTtest" WHERE c = 1;
84 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
85 DELETE FROM t WHERE c2="BUGbug";
86 SELECT * from t;
87 DROP TABLE t;
88
89 CREATE TABLE t (c INT PRIMARY KEY,c2 BLOB NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
90 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
91 UPDATE t SET c2=NULL WHERE c = 1;
92 UPDATE t SET c2="" WHERE c=1;
93 UPDATE t SET c2="TESTtest" WHERE c = 1;
94 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
95 DELETE FROM t WHERE c2="BUGbug";
96 SELECT * from t;
97 DROP TABLE t;
98 CREATE TABLE t (c INT PRIMARY KEY,c2 BLOB NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
99 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
100 UPDATE t SET c2=NULL WHERE c = 1;
101 UPDATE t SET c2="" WHERE c=1;
102 UPDATE t SET c2="TESTtest" WHERE c = 1;
103 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
104 DELETE FROM t WHERE c2="BUGbug";
105 SELECT * from t;
106 DROP TABLE t;
107 CREATE TABLE t (c INT PRIMARY KEY,c2 VARCHAR(270) NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
108 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
109 UPDATE t SET c2=NULL WHERE c = 1;
110 UPDATE t SET c2="" WHERE c=1;
111 UPDATE t SET c2="TESTtest" WHERE c = 1;
112 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
113 DELETE FROM t WHERE c2="BUGbug";
114 SELECT * from t;
115 DROP TABLE t;
116 CREATE TABLE t (c INT PRIMARY KEY,c2 VARCHAR(270) NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
117 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
118 UPDATE t SET c2=NULL WHERE c = 1;
119 UPDATE t SET c2="" WHERE c=1;
120 UPDATE t SET c2="TESTtest" WHERE c = 1;
121 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
122 DELETE FROM t WHERE c2="BUGbug";
123 SELECT * from t;
124 DROP TABLE t;
125 CREATE TABLE t (c INT PRIMARY KEY,c2 CHAR(80) NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
126 UPDATE t SET c2=NULL WHERE c = 1;
127 UPDATE t SET c2="" WHERE c=1;
128 UPDATE t SET c2="TESTtest" WHERE c = 1;
129 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
130 DELETE FROM t WHERE c2="BUGbug";
131 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
132 SELECT * from t;
133 DROP TABLE t;
134 CREATE TABLE t (c INT PRIMARY KEY,c2 CHAR(80) NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
135 UPDATE t SET c2=NULL WHERE c = 1;
136 UPDATE t SET c2="" WHERE c=1;
137 UPDATE t SET c2="TESTtest" WHERE c = 1;
138 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
139 DELETE FROM t WHERE c2="BUGbug";
140 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
141 SELECT * from t;
142 DROP TABLE t;
143 CREATE TABLE t (c INT PRIMARY KEY,c2 TEXT NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
144 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
145 UPDATE t SET c2=NULL WHERE c = 1;
146 UPDATE t SET c2="" WHERE c=1;
147 UPDATE t SET c2="TESTtest" WHERE c = 1;
148 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
149 DELETE FROM t WHERE c2="BUGbug";
150 SELECT * from t;
151 DROP TABLE t;
152 CREATE TABLE t (c INT PRIMARY KEY,c2 TEXT NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
153 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
154 UPDATE t SET c2=NULL WHERE c = 1;
155 UPDATE t SET c2="" WHERE c=1;
156 UPDATE t SET c2="TESTtest" WHERE c = 1;
157 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
158 DELETE FROM t WHERE c2="BUGbug";
159 SELECT * from t;
160 DROP TABLE t;
161
162 SET GLOBAL sql_mode=0;
163 SET sql_mode=DEFAULT;
164 CREATE TABLE t (c INT,c2 BLOB,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
165 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
166 UPDATE t SET c2=NULL WHERE c = 1;
167 UPDATE t SET c2="" WHERE c=1;
168 UPDATE t SET c2="TESTtest" WHERE c = 1;
169 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
170 DELETE FROM t WHERE c2="BUGbug";
171 SELECT * FROM t;
172 DROP TABLE t;
173 CREATE TABLE t (c INT,c2 BLOB NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
174 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
175 UPDATE t SET c2=NULL WHERE c = 1;
176 UPDATE t SET c2="" WHERE c=1;
177 UPDATE t SET c2="TESTtest" WHERE c = 1;
178 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
179 DELETE FROM t WHERE c2="BUGbug";
180 SELECT * FROM t;
181 DROP TABLE t;
182 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 BLOB,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
183 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
184 UPDATE t SET c2=NULL WHERE c = 1;
185 UPDATE t SET c2="" WHERE c=1;
186 UPDATE t SET c2="TESTtest" WHERE c = 1;
187 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
188 DELETE FROM t WHERE c2="BUGbug";
189 SELECT * FROM t;
190 DROP TABLE t;
191 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 BLOB NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
192 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
193 UPDATE t SET c2=NULL WHERE c = 1;
194 UPDATE t SET c2="" WHERE c=1;
195 UPDATE t SET c2="TESTtest" WHERE c = 1;
196 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
197 DELETE FROM t WHERE c2="BUGbug";
198 SELECT * FROM t;
199 DROP TABLE t;
200 CREATE TABLE t (c INT,c2 VARCHAR(270),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
201 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
202 UPDATE t SET c2=NULL WHERE c = 1;
203 UPDATE t SET c2="" WHERE c=1;
204 UPDATE t SET c2="TESTtest" WHERE c = 1;
205 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
206 DELETE FROM t WHERE c2="BUGbug";
207 SELECT * FROM t;
208 DROP TABLE t;
209 CREATE TABLE t (c INT,c2 VARCHAR(270) NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
210 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
211 UPDATE t SET c2=NULL WHERE c = 1;
212 UPDATE t SET c2="" WHERE c=1;
213 UPDATE t SET c2="TESTtest" WHERE c = 1;
214 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
215 DELETE FROM t WHERE c2="BUGbug";
216 SELECT * FROM t;
217 DROP TABLE t;
218 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 VARCHAR(270),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
219 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
220 UPDATE t SET c2=NULL WHERE c = 1;
221 UPDATE t SET c2="" WHERE c=1;
222 UPDATE t SET c2="TESTtest" WHERE c = 1;
223 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
224 DELETE FROM t WHERE c2="BUGbug";
225 SELECT * FROM t;
226 DROP TABLE t;
227 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 VARCHAR(270) NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
228 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
229 UPDATE t SET c2=NULL WHERE c = 1;
230 UPDATE t SET c2="" WHERE c=1;
231 UPDATE t SET c2="TESTtest" WHERE c = 1;
232 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
233 DELETE FROM t WHERE c2="BUGbug";
234 SELECT * FROM t;
235 DROP TABLE t;
236 CREATE TABLE t (c INT,c2 CHAR(80),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
237 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
238 UPDATE t SET c2=NULL WHERE c = 1;
239 UPDATE t SET c2="" WHERE c=1;
240 UPDATE t SET c2="TESTtest" WHERE c = 1;
241 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
242 DELETE FROM t WHERE c2="BUGbug";
243 SELECT * FROM t;
244 DROP TABLE t;
245 CREATE TABLE t (c INT,c2 CHAR(80) NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
246 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
247 UPDATE t SET c2=NULL WHERE c = 1;
248 UPDATE t SET c2="" WHERE c=1;
249 UPDATE t SET c2="TESTtest" WHERE c = 1;
250 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
251 DELETE FROM t WHERE c2="BUGbug";
252 SELECT * FROM t;
253 DROP TABLE t;
254 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 CHAR(80),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
255 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
256 UPDATE t SET c2=NULL WHERE c = 1;
257 UPDATE t SET c2="" WHERE c=1;
258 UPDATE t SET c2="TESTtest" WHERE c = 1;
259 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
260 DELETE FROM t WHERE c2="BUGbug";
261 SELECT * FROM t;
262 DROP TABLE t;
263 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 CHAR(80) NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
264 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
265 UPDATE t SET c2=NULL WHERE c = 1;
266 UPDATE t SET c2="" WHERE c=1;
267 UPDATE t SET c2="TESTtest" WHERE c = 1;
268 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
269 DELETE FROM t WHERE c2="BUGbug";
270 SELECT * FROM t;
271 DROP TABLE t;
272 CREATE TABLE t (c INT,c2 TEXT,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
273 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
274 UPDATE t SET c2=NULL WHERE c = 1;
275 UPDATE t SET c2="TESTtest" WHERE c = 1;
276 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
277 DELETE FROM t WHERE c2="BUGbug";
278 SELECT * FROM t;
279 DROP TABLE t;
280 CREATE TABLE t (c INT,c2 TEXT NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
281 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
282 UPDATE t SET c2=NULL WHERE c = 1;
283 UPDATE t SET c2="TESTtest" WHERE c = 1;
284 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
285 DELETE FROM t WHERE c2="BUGbug";
286 SELECT * FROM t;
287 DROP TABLE t;
288 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 TEXT,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
289 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
290 UPDATE t SET c2=NULL WHERE c = 1;
291 UPDATE t SET c2="TESTtest" WHERE c = 1;
292 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
293 DELETE FROM t WHERE c2="BUGbug";
294 SELECT * FROM t;
295 DROP TABLE t;
296 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 TEXT NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
297 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
298 UPDATE t SET c2=NULL WHERE c = 1;
299 UPDATE t SET c2="TESTtest" WHERE c = 1;
300 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
301 DELETE FROM t WHERE c2="BUGbug";
302 SELECT * FROM t;
303 DROP TABLE t;
304
305 SET GLOBAL sql_mode=DEFAULT;
306
307 CREATE TABLE t (c INT,c2 BLOB,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
308 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
309 UPDATE t SET c2=NULL WHERE c = 1;
310 UPDATE t SET c2="TESTtest" WHERE c = 1;
311 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
312 DELETE FROM t WHERE c2="BUGbug";
313 SELECT * FROM t;
314 DROP TABLE t;
315 CREATE TABLE t (c INT,c2 VARCHAR(270),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
316 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
317 UPDATE t SET c2=NULL WHERE c = 1;
318 UPDATE t SET c2="TESTtest" WHERE c = 1;
319 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
320 DELETE FROM t WHERE c2="BUGbug";
321 SELECT * FROM t;
322 DROP TABLE t;
323 CREATE TABLE t (c INT,c2 CHAR(80),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
324 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
325 UPDATE t SET c2=NULL WHERE c = 1;
326 UPDATE t SET c2="TESTtest" WHERE c = 1;
327 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
328 DELETE FROM t WHERE c2="BUGbug";
329 SELECT * FROM t;
330 DROP TABLE t;
331 CREATE TABLE t (c INT,c2 TEXT,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
332 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
333 UPDATE t SET c2=NULL WHERE c = 1;
334 UPDATE t SET c2="TESTtest" WHERE c = 1;
335 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
336 DELETE FROM t WHERE c2="BUGbug";
337 SELECT * FROM t;
338 DROP TABLE t;
339
340 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 BLOB,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
341 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
342 UPDATE t SET c2=NULL WHERE c = 1;
343 UPDATE t SET c2="TESTtest" WHERE c = 1;
344 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
345 DELETE FROM t WHERE c2="BUGbug";
346 SELECT * FROM t;
347 DROP TABLE t;
348 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 VARCHAR(270),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
349 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
350 UPDATE t SET c2=NULL WHERE c = 1;
351 UPDATE t SET c2="TESTtest" WHERE c = 1;
352 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
353 DELETE FROM t WHERE c2="BUGbug";
354 SELECT * FROM t;
355 DROP TABLE t;
356 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 CHAR(80),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
357 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
358 UPDATE t SET c2=NULL WHERE c = 1;
359 UPDATE t SET c2="TESTtest" WHERE c = 1;
360 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
361 DELETE FROM t WHERE c2="BUGbug";
362 SELECT * FROM t;
363 DROP TABLE t;
364 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 TEXT,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
365 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
366 UPDATE t SET c2=NULL WHERE c = 1;
367 UPDATE t SET c2="TESTtest" WHERE c = 1;
368 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
369 DELETE FROM t WHERE c2="BUGbug";
370 SELECT * FROM t;
371 DROP TABLE t;