Debian Codegraph @

mysql-test/suite/galera/r/MDEV-30732.result

raw
1 connection node_2;
2 connection node_1;
3 SET GLOBAL sql_mode=0;
4 SET sql_mode=DEFAULT;
5 CREATE TABLE t (c INT,c2 BLOB NOT NULL,KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
6 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
7 Warnings:
8 Warning 1364 Field 'c2' doesn't have a default value
9 SELECT * from t;
10 c c2
11 1
12 1
13 1
14 1
15 1
16 DROP TABLE t;
17 CREATE TABLE t (c INT,c2 BLOB NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
18 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
19 Warnings:
20 Warning 1364 Field 'c2' doesn't have a default value
21 UPDATE t SET c2=NULL WHERE c = 1;
22 Warnings:
23 Warning 1048 Column 'c2' cannot be null
24 UPDATE t SET c2="" WHERE c=1;
25 UPDATE t SET c2="TESTtest" WHERE c = 1;
26 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
27 DELETE FROM t WHERE c2="BUGbug";
28 SELECT * from t;
29 c c2
30 2
31 3
32 4
33 5
34 DROP TABLE t;
35 CREATE TABLE t (c INT,c2 BLOB NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
36 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
37 Warnings:
38 Warning 1364 Field 'c2' doesn't have a default value
39 UPDATE t SET c2=NULL WHERE c = 1;
40 Warnings:
41 Warning 1048 Column 'c2' cannot be null
42 UPDATE t SET c2="" WHERE c=1;
43 UPDATE t SET c2="TESTtest" WHERE c = 1;
44 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
45 DELETE FROM t WHERE c2="BUGbug";
46 SELECT * from t;
47 c c2
48 2
49 3
50 4
51 5
52 DROP TABLE t;
53 CREATE TABLE t (c INT,c2 VARCHAR(270) NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
54 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
55 Warnings:
56 Warning 1364 Field 'c2' doesn't have a default value
57 UPDATE t SET c2=NULL WHERE c = 1;
58 Warnings:
59 Warning 1048 Column 'c2' cannot be null
60 UPDATE t SET c2="" WHERE c=1;
61 UPDATE t SET c2="TESTtest" WHERE c = 1;
62 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
63 DELETE FROM t WHERE c2="BUGbug";
64 SELECT * from t;
65 c c2
66 2
67 3
68 4
69 5
70 DROP TABLE t;
71 CREATE TABLE t (c INT,c2 VARCHAR(270) NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
72 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
73 Warnings:
74 Warning 1364 Field 'c2' doesn't have a default value
75 UPDATE t SET c2=NULL WHERE c = 1;
76 Warnings:
77 Warning 1048 Column 'c2' cannot be null
78 UPDATE t SET c2="" WHERE c=1;
79 UPDATE t SET c2="TESTtest" WHERE c = 1;
80 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
81 DELETE FROM t WHERE c2="BUGbug";
82 SELECT * from t;
83 c c2
84 2
85 3
86 4
87 5
88 DROP TABLE t;
89 CREATE TABLE t (c INT,c2 CHAR(80) NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
90 UPDATE t SET c2=NULL WHERE c = 1;
91 UPDATE t SET c2="" WHERE c=1;
92 UPDATE t SET c2="TESTtest" WHERE c = 1;
93 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
94 DELETE FROM t WHERE c2="BUGbug";
95 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
96 Warnings:
97 Warning 1364 Field 'c2' doesn't have a default value
98 SELECT * from t;
99 c c2
100 1
101 2
102 3
103 4
104 5
105 DROP TABLE t;
106 CREATE TABLE t (c INT,c2 CHAR(80) NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
107 UPDATE t SET c2=NULL WHERE c = 1;
108 UPDATE t SET c2="" WHERE c=1;
109 UPDATE t SET c2="TESTtest" WHERE c = 1;
110 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
111 DELETE FROM t WHERE c2="BUGbug";
112 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
113 Warnings:
114 Warning 1364 Field 'c2' doesn't have a default value
115 SELECT * from t;
116 c c2
117 1
118 2
119 3
120 4
121 5
122 DROP TABLE t;
123 CREATE TABLE t (c INT,c2 TEXT NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
124 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
125 Warnings:
126 Warning 1364 Field 'c2' doesn't have a default value
127 UPDATE t SET c2=NULL WHERE c = 1;
128 Warnings:
129 Warning 1048 Column 'c2' cannot be null
130 UPDATE t SET c2="" WHERE c=1;
131 UPDATE t SET c2="TESTtest" WHERE c = 1;
132 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
133 DELETE FROM t WHERE c2="BUGbug";
134 SELECT * from t;
135 c c2
136 2
137 3
138 4
139 5
140 DROP TABLE t;
141 CREATE TABLE t (c INT,c2 TEXT NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
142 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
143 Warnings:
144 Warning 1364 Field 'c2' doesn't have a default value
145 UPDATE t SET c2=NULL WHERE c = 1;
146 Warnings:
147 Warning 1048 Column 'c2' cannot be null
148 UPDATE t SET c2="" WHERE c=1;
149 UPDATE t SET c2="TESTtest" WHERE c = 1;
150 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
151 DELETE FROM t WHERE c2="BUGbug";
152 SELECT * from t;
153 c c2
154 2
155 3
156 4
157 5
158 DROP TABLE t;
159 CREATE TABLE t (c INT PRIMARY KEY,c2 BLOB NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
160 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
161 Warnings:
162 Warning 1364 Field 'c2' doesn't have a default value
163 UPDATE t SET c2=NULL WHERE c = 1;
164 Warnings:
165 Warning 1048 Column 'c2' cannot be null
166 UPDATE t SET c2="" WHERE c=1;
167 UPDATE t SET c2="TESTtest" WHERE c = 1;
168 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
169 DELETE FROM t WHERE c2="BUGbug";
170 SELECT * from t;
171 c c2
172 2
173 3
174 4
175 5
176 DROP TABLE t;
177 CREATE TABLE t (c INT PRIMARY KEY,c2 BLOB NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
178 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
179 Warnings:
180 Warning 1364 Field 'c2' doesn't have a default value
181 UPDATE t SET c2=NULL WHERE c = 1;
182 Warnings:
183 Warning 1048 Column 'c2' cannot be null
184 UPDATE t SET c2="" WHERE c=1;
185 UPDATE t SET c2="TESTtest" WHERE c = 1;
186 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
187 DELETE FROM t WHERE c2="BUGbug";
188 SELECT * from t;
189 c c2
190 2
191 3
192 4
193 5
194 DROP TABLE t;
195 CREATE TABLE t (c INT PRIMARY KEY,c2 VARCHAR(270) NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
196 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
197 Warnings:
198 Warning 1364 Field 'c2' doesn't have a default value
199 UPDATE t SET c2=NULL WHERE c = 1;
200 Warnings:
201 Warning 1048 Column 'c2' cannot be null
202 UPDATE t SET c2="" WHERE c=1;
203 UPDATE t SET c2="TESTtest" WHERE c = 1;
204 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
205 DELETE FROM t WHERE c2="BUGbug";
206 SELECT * from t;
207 c c2
208 2
209 3
210 4
211 5
212 DROP TABLE t;
213 CREATE TABLE t (c INT PRIMARY KEY,c2 VARCHAR(270) NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
214 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
215 Warnings:
216 Warning 1364 Field 'c2' doesn't have a default value
217 UPDATE t SET c2=NULL WHERE c = 1;
218 Warnings:
219 Warning 1048 Column 'c2' cannot be null
220 UPDATE t SET c2="" WHERE c=1;
221 UPDATE t SET c2="TESTtest" WHERE c = 1;
222 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
223 DELETE FROM t WHERE c2="BUGbug";
224 SELECT * from t;
225 c c2
226 2
227 3
228 4
229 5
230 DROP TABLE t;
231 CREATE TABLE t (c INT PRIMARY KEY,c2 CHAR(80) NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
232 UPDATE t SET c2=NULL WHERE c = 1;
233 UPDATE t SET c2="" WHERE c=1;
234 UPDATE t SET c2="TESTtest" WHERE c = 1;
235 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
236 DELETE FROM t WHERE c2="BUGbug";
237 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
238 Warnings:
239 Warning 1364 Field 'c2' doesn't have a default value
240 SELECT * from t;
241 c c2
242 1
243 2
244 3
245 4
246 5
247 DROP TABLE t;
248 CREATE TABLE t (c INT PRIMARY KEY,c2 CHAR(80) NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
249 UPDATE t SET c2=NULL WHERE c = 1;
250 UPDATE t SET c2="" WHERE c=1;
251 UPDATE t SET c2="TESTtest" WHERE c = 1;
252 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
253 DELETE FROM t WHERE c2="BUGbug";
254 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
255 Warnings:
256 Warning 1364 Field 'c2' doesn't have a default value
257 SELECT * from t;
258 c c2
259 1
260 2
261 3
262 4
263 5
264 DROP TABLE t;
265 CREATE TABLE t (c INT PRIMARY KEY,c2 TEXT NOT NULL,UNIQUE KEY k2 (c2 (1),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
266 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
267 Warnings:
268 Warning 1364 Field 'c2' doesn't have a default value
269 UPDATE t SET c2=NULL WHERE c = 1;
270 Warnings:
271 Warning 1048 Column 'c2' cannot be null
272 UPDATE t SET c2="" WHERE c=1;
273 UPDATE t SET c2="TESTtest" WHERE c = 1;
274 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
275 DELETE FROM t WHERE c2="BUGbug";
276 SELECT * from t;
277 c c2
278 2
279 3
280 4
281 5
282 DROP TABLE t;
283 CREATE TABLE t (c INT PRIMARY KEY,c2 TEXT NOT NULL,KEY k2 (c, c2 (1))) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
284 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
285 Warnings:
286 Warning 1364 Field 'c2' doesn't have a default value
287 UPDATE t SET c2=NULL WHERE c = 1;
288 Warnings:
289 Warning 1048 Column 'c2' cannot be null
290 UPDATE t SET c2="" 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 c c2
296 2
297 3
298 4
299 5
300 DROP TABLE t;
301 SET GLOBAL sql_mode=0;
302 SET sql_mode=DEFAULT;
303 CREATE TABLE t (c INT,c2 BLOB,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
304 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
305 UPDATE t SET c2=NULL WHERE c = 1;
306 UPDATE t SET c2="" WHERE c=1;
307 UPDATE t SET c2="TESTtest" WHERE c = 1;
308 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
309 DELETE FROM t WHERE c2="BUGbug";
310 SELECT * FROM t;
311 c c2
312 DROP TABLE t;
313 CREATE TABLE t (c INT,c2 BLOB NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
314 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
315 Warnings:
316 Warning 1364 Field 'c2' doesn't have a default value
317 UPDATE t SET c2=NULL WHERE c = 1;
318 Warnings:
319 Warning 1048 Column 'c2' cannot be null
320 Warning 1048 Column 'c2' cannot be null
321 Warning 1048 Column 'c2' cannot be null
322 Warning 1048 Column 'c2' cannot be null
323 Warning 1048 Column 'c2' cannot be null
324 UPDATE t SET c2="" WHERE c=1;
325 UPDATE t SET c2="TESTtest" WHERE c = 1;
326 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
327 DELETE FROM t WHERE c2="BUGbug";
328 SELECT * FROM t;
329 c c2
330 DROP TABLE t;
331 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 BLOB,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
332 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
333 UPDATE t SET c2=NULL WHERE c = 1;
334 UPDATE t SET c2="" WHERE c=1;
335 UPDATE t SET c2="TESTtest" WHERE c = 1;
336 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
337 DELETE FROM t WHERE c2="BUGbug";
338 SELECT * FROM t;
339 c c2
340 2 NULL
341 3 NULL
342 4 NULL
343 5 NULL
344 DROP TABLE t;
345 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 BLOB NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
346 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
347 Warnings:
348 Warning 1364 Field 'c2' doesn't have a default value
349 UPDATE t SET c2=NULL WHERE c = 1;
350 Warnings:
351 Warning 1048 Column 'c2' cannot be null
352 UPDATE t SET c2="" WHERE c=1;
353 UPDATE t SET c2="TESTtest" WHERE c = 1;
354 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
355 DELETE FROM t WHERE c2="BUGbug";
356 SELECT * FROM t;
357 c c2
358 2
359 3
360 4
361 5
362 DROP TABLE t;
363 CREATE TABLE t (c INT,c2 VARCHAR(270),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
364 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
365 UPDATE t SET c2=NULL WHERE c = 1;
366 UPDATE t SET c2="" 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 c c2
372 DROP TABLE t;
373 CREATE TABLE t (c INT,c2 VARCHAR(270) NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
374 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
375 Warnings:
376 Warning 1364 Field 'c2' doesn't have a default value
377 UPDATE t SET c2=NULL WHERE c = 1;
378 Warnings:
379 Warning 1048 Column 'c2' cannot be null
380 Warning 1048 Column 'c2' cannot be null
381 Warning 1048 Column 'c2' cannot be null
382 Warning 1048 Column 'c2' cannot be null
383 Warning 1048 Column 'c2' cannot be null
384 UPDATE t SET c2="" WHERE c=1;
385 UPDATE t SET c2="TESTtest" WHERE c = 1;
386 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
387 DELETE FROM t WHERE c2="BUGbug";
388 SELECT * FROM t;
389 c c2
390 DROP TABLE t;
391 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 VARCHAR(270),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
392 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
393 UPDATE t SET c2=NULL WHERE c = 1;
394 UPDATE t SET c2="" WHERE c=1;
395 UPDATE t SET c2="TESTtest" WHERE c = 1;
396 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
397 DELETE FROM t WHERE c2="BUGbug";
398 SELECT * FROM t;
399 c c2
400 2 NULL
401 3 NULL
402 4 NULL
403 5 NULL
404 DROP TABLE t;
405 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;
406 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
407 Warnings:
408 Warning 1364 Field 'c2' doesn't have a default value
409 UPDATE t SET c2=NULL WHERE c = 1;
410 Warnings:
411 Warning 1048 Column 'c2' cannot be null
412 UPDATE t SET c2="" WHERE c=1;
413 UPDATE t SET c2="TESTtest" WHERE c = 1;
414 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
415 DELETE FROM t WHERE c2="BUGbug";
416 SELECT * FROM t;
417 c c2
418 2
419 3
420 4
421 5
422 DROP TABLE t;
423 CREATE TABLE t (c INT,c2 CHAR(80),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
424 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
425 UPDATE t SET c2=NULL WHERE c = 1;
426 UPDATE t SET c2="" WHERE c=1;
427 UPDATE t SET c2="TESTtest" WHERE c = 1;
428 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
429 DELETE FROM t WHERE c2="BUGbug";
430 SELECT * FROM t;
431 c c2
432 DROP TABLE t;
433 CREATE TABLE t (c INT,c2 CHAR(80) NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
434 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
435 Warnings:
436 Warning 1364 Field 'c2' doesn't have a default value
437 UPDATE t SET c2=NULL WHERE c = 1;
438 Warnings:
439 Warning 1048 Column 'c2' cannot be null
440 Warning 1048 Column 'c2' cannot be null
441 Warning 1048 Column 'c2' cannot be null
442 Warning 1048 Column 'c2' cannot be null
443 Warning 1048 Column 'c2' cannot be null
444 UPDATE t SET c2="" WHERE c=1;
445 UPDATE t SET c2="TESTtest" WHERE c = 1;
446 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
447 DELETE FROM t WHERE c2="BUGbug";
448 SELECT * FROM t;
449 c c2
450 DROP TABLE t;
451 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 CHAR(80),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
452 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
453 UPDATE t SET c2=NULL WHERE c = 1;
454 UPDATE t SET c2="" WHERE c=1;
455 UPDATE t SET c2="TESTtest" WHERE c = 1;
456 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
457 DELETE FROM t WHERE c2="BUGbug";
458 SELECT * FROM t;
459 c c2
460 2 NULL
461 3 NULL
462 4 NULL
463 5 NULL
464 DROP TABLE t;
465 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;
466 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
467 Warnings:
468 Warning 1364 Field 'c2' doesn't have a default value
469 UPDATE t SET c2=NULL WHERE c = 1;
470 Warnings:
471 Warning 1048 Column 'c2' cannot be null
472 UPDATE t SET c2="" WHERE c=1;
473 UPDATE t SET c2="TESTtest" WHERE c = 1;
474 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
475 DELETE FROM t WHERE c2="BUGbug";
476 SELECT * FROM t;
477 c c2
478 2
479 3
480 4
481 5
482 DROP TABLE t;
483 CREATE TABLE t (c INT,c2 TEXT,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
484 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
485 UPDATE t SET c2=NULL WHERE c = 1;
486 UPDATE t SET c2="TESTtest" WHERE c = 1;
487 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
488 DELETE FROM t WHERE c2="BUGbug";
489 SELECT * FROM t;
490 c c2
491 DROP TABLE t;
492 CREATE TABLE t (c INT,c2 TEXT NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
493 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
494 Warnings:
495 Warning 1364 Field 'c2' doesn't have a default value
496 UPDATE t SET c2=NULL WHERE c = 1;
497 Warnings:
498 Warning 1048 Column 'c2' cannot be null
499 Warning 1048 Column 'c2' cannot be null
500 Warning 1048 Column 'c2' cannot be null
501 Warning 1048 Column 'c2' cannot be null
502 Warning 1048 Column 'c2' cannot be null
503 UPDATE t SET c2="TESTtest" WHERE c = 1;
504 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
505 DELETE FROM t WHERE c2="BUGbug";
506 SELECT * FROM t;
507 c c2
508 DROP TABLE t;
509 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 TEXT,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
510 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
511 UPDATE t SET c2=NULL WHERE c = 1;
512 UPDATE t SET c2="TESTtest" WHERE c = 1;
513 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
514 DELETE FROM t WHERE c2="BUGbug";
515 SELECT * FROM t;
516 c c2
517 2 NULL
518 3 NULL
519 4 NULL
520 5 NULL
521 DROP TABLE t;
522 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 TEXT NOT NULL,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
523 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
524 Warnings:
525 Warning 1364 Field 'c2' doesn't have a default value
526 UPDATE t SET c2=NULL WHERE c = 1;
527 Warnings:
528 Warning 1048 Column 'c2' cannot be null
529 UPDATE t SET c2="TESTtest" WHERE c = 1;
530 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
531 DELETE FROM t WHERE c2="BUGbug";
532 SELECT * FROM t;
533 c c2
534 2
535 3
536 4
537 5
538 DROP TABLE t;
539 SET GLOBAL sql_mode=DEFAULT;
540 CREATE TABLE t (c INT,c2 BLOB,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
541 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
542 UPDATE t SET c2=NULL WHERE c = 1;
543 UPDATE t SET c2="TESTtest" WHERE c = 1;
544 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
545 DELETE FROM t WHERE c2="BUGbug";
546 SELECT * FROM t;
547 c c2
548 DROP TABLE t;
549 CREATE TABLE t (c INT,c2 VARCHAR(270),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
550 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
551 UPDATE t SET c2=NULL WHERE c = 1;
552 UPDATE t SET c2="TESTtest" WHERE c = 1;
553 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
554 DELETE FROM t WHERE c2="BUGbug";
555 SELECT * FROM t;
556 c c2
557 DROP TABLE t;
558 CREATE TABLE t (c INT,c2 CHAR(80),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
559 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
560 UPDATE t SET c2=NULL WHERE c = 1;
561 UPDATE t SET c2="TESTtest" WHERE c = 1;
562 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
563 DELETE FROM t WHERE c2="BUGbug";
564 SELECT * FROM t;
565 c c2
566 DROP TABLE t;
567 CREATE TABLE t (c INT,c2 TEXT,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
568 INSERT INTO t (c) VALUES (1),(1),(1),(1),(1);
569 UPDATE t SET c2=NULL WHERE c = 1;
570 UPDATE t SET c2="TESTtest" WHERE c = 1;
571 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
572 DELETE FROM t WHERE c2="BUGbug";
573 SELECT * FROM t;
574 c c2
575 DROP TABLE t;
576 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 BLOB,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
577 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
578 UPDATE t SET c2=NULL WHERE c = 1;
579 UPDATE t SET c2="TESTtest" WHERE c = 1;
580 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
581 DELETE FROM t WHERE c2="BUGbug";
582 SELECT * FROM t;
583 c c2
584 2 NULL
585 3 NULL
586 4 NULL
587 5 NULL
588 DROP TABLE t;
589 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 VARCHAR(270),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
590 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
591 UPDATE t SET c2=NULL WHERE c = 1;
592 UPDATE t SET c2="TESTtest" WHERE c = 1;
593 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
594 DELETE FROM t WHERE c2="BUGbug";
595 SELECT * FROM t;
596 c c2
597 2 NULL
598 3 NULL
599 4 NULL
600 5 NULL
601 DROP TABLE t;
602 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 CHAR(80),KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
603 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
604 UPDATE t SET c2=NULL WHERE c = 1;
605 UPDATE t SET c2="TESTtest" WHERE c = 1;
606 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
607 DELETE FROM t WHERE c2="BUGbug";
608 SELECT * FROM t;
609 c c2
610 2 NULL
611 3 NULL
612 4 NULL
613 5 NULL
614 DROP TABLE t;
615 CREATE TABLE t (c INT NOT NULL PRIMARY KEY,c2 TEXT,KEY k2 (c2 (6),c)) DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
616 INSERT INTO t (c) VALUES (1),(2),(3),(4),(5);
617 UPDATE t SET c2=NULL WHERE c = 1;
618 UPDATE t SET c2="TESTtest" WHERE c = 1;
619 UPDATE t SET c2="BUGbug" WHERE c2 = "TESTtest";
620 DELETE FROM t WHERE c2="BUGbug";
621 SELECT * FROM t;
622 c c2
623 2 NULL
624 3 NULL
625 4 NULL
626 5 NULL
627 DROP TABLE t;