Debian Codegraph @

mysql-test/suite/engines/iuds/r/update_time.result

raw
1 DROP TABLE IF EXISTS t1,t2,t3,t4;
2 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, PRIMARY KEY(c1));
3 CREATE TABLE t2(c1 TIME NOT NULL, c2 TIME NULL, PRIMARY KEY(c1,c2));
4 CREATE TABLE t3(c1 TIME NOT NULL, c2 TIME NULL, UNIQUE INDEX idx(c1,c2));
5 CREATE TABLE t4(c1 TIME NOT NULL, c2 TIME NULL);
6 INSERT INTO t1 VALUES ('00:00:00.00','00:00:00.00'),('01:01:01.01','01:01:01.00'),('838:59:59.00','838:59:59.00'),('00:00:01','00:00:01'),('02:02:02','02:02:02'),('838:59:58','838:59:58'),('-838:59:59','-838:59:59'),('00:03','00:03'),('03:03','03:03'),('838:58','838:58'),('00 00:00:04','00 00:00:04'),('04 04:04:04','04 04:04:04'),('34 22:59:57','34 22:59:57'),('00 00:04','00 00:04'),('05 05:05','05 05:05'),('34 22:56','34 22:56'),('05 05','05 05'),('06 06','06 06'),('34 22','34 22'),('07','07'),('59','59');
7 INSERT INTO t2 VALUES ('00:00:00.00','00:00:00.00'),('01:01:01.01','01:01:01.00'),('838:59:59.00','838:59:59.00'),('00:00:01','00:00:01'),('02:02:02','02:02:02'),('838:59:58','838:59:58'),('-838:59:59','-838:59:59'),('00:03','00:03'),('03:03','03:03'),('838:58','838:58'),('00 00:00:04','00 00:00:04'),('04 04:04:04','04 04:04:04'),('34 22:59:57','34 22:59:57'),('00 00:04','00 00:04'),('05 05:05','05 05:05'),('34 22:56','34 22:56'),('05 05','05 05'),('06 06','06 06'),('34 22','34 22'),('07','07'),('59','59');
8 INSERT INTO t3 VALUES ('00:00:00.00','00:00:00.00'),('01:01:01.01','01:01:01.00'),('838:59:59.00','838:59:59.00'),('00:00:01','00:00:01'),('02:02:02','02:02:02'),('838:59:58','838:59:58'),('-838:59:59','-838:59:59'),('00:03','00:03'),('03:03','03:03'),('838:58','838:58'),('00 00:00:04','00 00:00:04'),('04 04:04:04','04 04:04:04'),('34 22:59:57','34 22:59:57'),('00 00:04','00 00:04'),('05 05:05','05 05:05'),('34 22:56','34 22:56'),('05 05','05 05'),('06 06','06 06'),('34 22','34 22'),('07','07'),('59','59');
9 INSERT INTO t4 VALUES ('00:00:00.00','00:00:00.00'),('01:01:01.01','01:01:01.00'),('838:59:59.00','838:59:59.00'),('00:00:01','00:00:01'),('02:02:02','02:02:02'),('838:59:58','838:59:58'),('-838:59:59','-838:59:59'),('00:03','00:03'),('03:03','03:03'),('838:58','838:58'),('00 00:00:04','00 00:00:04'),('04 04:04:04','04 04:04:04'),('34 22:59:57','34 22:59:57'),('00 00:04','00 00:04'),('05 05:05','05 05:05'),('34 22:56','34 22:56'),('05 05','05 05'),('06 06','06 06'),('34 22','34 22'),('07','07'),('59','59');
10 INSERT INTO t1 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53');
11 INSERT INTO t2 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53');
12 INSERT INTO t3 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53');
13 INSERT INTO t4 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53');
14 INSERT INTO t1 VALUES (000011.00,000011.00),(111111.11,111111.11),(8385952.00,8385952.00),(000012,000012),(121212,121212),(8385951,8385951),(1313,1313),(5151,5151),(14,14),(50,50);
15 INSERT INTO t2 VALUES (000011.00,000011.00),(111111.11,111111.11),(8385952.00,8385952.00),(000012,000012),(121212,121212),(8385951,8385951),(1313,1313),(5151,5151),(14,14),(50,50);
16 INSERT INTO t3 VALUES (000011.00,000011.00),(111111.11,111111.11),(8385952.00,8385952.00),(000012,000012),(121212,121212),(8385951,8385951),(1313,1313),(5151,5151),(14,14),(50,50);
17 INSERT INTO t4 VALUES (000011.00,000011.00),(111111.11,111111.11),(8385952.00,8385952.00),(000012,000012),(121212,121212),(8385951,8385951),(1313,1313),(5151,5151),(14,14),(50,50);
18 SET TIMESTAMP=1233216687;
19 INSERT INTO t1 VALUES(CURRENT_TIME(),CURRENT_TIME());
20 INSERT INTO t2 VALUES(CURRENT_TIME(),CURRENT_TIME());
21 INSERT INTO t3 VALUES(CURRENT_TIME(),CURRENT_TIME());
22 INSERT INTO t4 VALUES(CURRENT_TIME(),CURRENT_TIME());
23 INSERT INTO t1 VALUES('123456',null);
24 INSERT INTO t3 VALUES('123456',null);
25 INSERT INTO t4 VALUES('123456',null);
26 SELECT * FROM t1;
27 c1 c2
28 -838:59:55 -838:59:55
29 -838:59:59 -838:59:59
30 00:00:00 00:00:00
31 00:00:01 00:00:01
32 00:00:04 00:00:04
33 00:00:07 00:00:07
34 00:00:08 00:00:08
35 00:00:09 00:00:09
36 00:00:10 00:00:10
37 00:00:11 00:00:11
38 00:00:12 00:00:12
39 00:00:14 00:00:14
40 00:00:50 00:00:50
41 00:00:53 00:00:53
42 00:00:59 00:00:59
43 00:03:00 00:03:00
44 00:04:00 00:04:00
45 00:09:09 00:09:09
46 00:13:13 00:13:13
47 00:51:51 00:51:51
48 00:54:54 00:54:54
49 01:01:01 01:01:01
50 02:02:02 02:02:02
51 03:03:00 03:03:00
52 08:08:08 08:08:08
53 100:04:04 100:04:04
54 11:11:11 11:11:11
55 11:11:27 11:11:27
56 125:00:00 125:00:00
57 125:05:00 125:05:00
58 12:12:12 12:12:12
59 12:34:56 NULL
60 150:00:00 150:00:00
61 838:00:00 838:00:00
62 838:56:00 838:56:00
63 838:58:00 838:58:00
64 838:59:51 838:59:51
65 838:59:52 838:59:52
66 838:59:55 838:59:55
67 838:59:57 838:59:57
68 838:59:58 838:59:58
69 838:59:59 838:59:59
70 SELECT * FROM t2;
71 c1 c2
72 -838:59:55 -838:59:55
73 -838:59:59 -838:59:59
74 00:00:00 00:00:00
75 00:00:01 00:00:01
76 00:00:04 00:00:04
77 00:00:07 00:00:07
78 00:00:08 00:00:08
79 00:00:09 00:00:09
80 00:00:10 00:00:10
81 00:00:11 00:00:11
82 00:00:12 00:00:12
83 00:00:14 00:00:14
84 00:00:50 00:00:50
85 00:00:53 00:00:53
86 00:00:59 00:00:59
87 00:03:00 00:03:00
88 00:04:00 00:04:00
89 00:09:09 00:09:09
90 00:13:13 00:13:13
91 00:51:51 00:51:51
92 00:54:54 00:54:54
93 01:01:01 01:01:01
94 02:02:02 02:02:02
95 03:03:00 03:03:00
96 08:08:08 08:08:08
97 100:04:04 100:04:04
98 11:11:11 11:11:11
99 11:11:27 11:11:27
100 125:00:00 125:00:00
101 125:05:00 125:05:00
102 12:12:12 12:12:12
103 150:00:00 150:00:00
104 838:00:00 838:00:00
105 838:56:00 838:56:00
106 838:58:00 838:58:00
107 838:59:51 838:59:51
108 838:59:52 838:59:52
109 838:59:55 838:59:55
110 838:59:57 838:59:57
111 838:59:58 838:59:58
112 838:59:59 838:59:59
113 SELECT * FROM t3;
114 c1 c2
115 -838:59:55 -838:59:55
116 -838:59:59 -838:59:59
117 00:00:00 00:00:00
118 00:00:01 00:00:01
119 00:00:04 00:00:04
120 00:00:07 00:00:07
121 00:00:08 00:00:08
122 00:00:09 00:00:09
123 00:00:10 00:00:10
124 00:00:11 00:00:11
125 00:00:12 00:00:12
126 00:00:14 00:00:14
127 00:00:50 00:00:50
128 00:00:53 00:00:53
129 00:00:59 00:00:59
130 00:03:00 00:03:00
131 00:04:00 00:04:00
132 00:09:09 00:09:09
133 00:13:13 00:13:13
134 00:51:51 00:51:51
135 00:54:54 00:54:54
136 01:01:01 01:01:01
137 02:02:02 02:02:02
138 03:03:00 03:03:00
139 08:08:08 08:08:08
140 100:04:04 100:04:04
141 11:11:11 11:11:11
142 11:11:27 11:11:27
143 125:00:00 125:00:00
144 125:05:00 125:05:00
145 12:12:12 12:12:12
146 12:34:56 NULL
147 150:00:00 150:00:00
148 838:00:00 838:00:00
149 838:56:00 838:56:00
150 838:58:00 838:58:00
151 838:59:51 838:59:51
152 838:59:52 838:59:52
153 838:59:55 838:59:55
154 838:59:57 838:59:57
155 838:59:58 838:59:58
156 838:59:59 838:59:59
157 SELECT * FROM t4;
158 c1 c2
159 -838:59:55 -838:59:55
160 -838:59:59 -838:59:59
161 00:00:00 00:00:00
162 00:00:01 00:00:01
163 00:00:04 00:00:04
164 00:00:07 00:00:07
165 00:00:08 00:00:08
166 00:00:09 00:00:09
167 00:00:10 00:00:10
168 00:00:11 00:00:11
169 00:00:12 00:00:12
170 00:00:14 00:00:14
171 00:00:50 00:00:50
172 00:00:53 00:00:53
173 00:00:59 00:00:59
174 00:03:00 00:03:00
175 00:04:00 00:04:00
176 00:09:09 00:09:09
177 00:13:13 00:13:13
178 00:51:51 00:51:51
179 00:54:54 00:54:54
180 01:01:01 01:01:01
181 02:02:02 02:02:02
182 03:03:00 03:03:00
183 08:08:08 08:08:08
184 100:04:04 100:04:04
185 11:11:11 11:11:11
186 11:11:27 11:11:27
187 125:00:00 125:00:00
188 125:05:00 125:05:00
189 12:12:12 12:12:12
190 12:34:56 NULL
191 150:00:00 150:00:00
192 838:00:00 838:00:00
193 838:56:00 838:56:00
194 838:58:00 838:58:00
195 838:59:51 838:59:51
196 838:59:52 838:59:52
197 838:59:55 838:59:55
198 838:59:57 838:59:57
199 838:59:58 838:59:58
200 838:59:59 838:59:59
201 SELECT c1 FROM t1 WHERE c1='00:00:07';
202 c1
203 00:00:07
204 UPDATE t1 SET c1='22:22:22' WHERE c1='00:00:07';
205 SELECT c1 FROM t1;
206 c1
207 -838:59:55
208 -838:59:59
209 00:00:00
210 00:00:01
211 00:00:04
212 00:00:08
213 00:00:09
214 00:00:10
215 00:00:11
216 00:00:12
217 00:00:14
218 00:00:50
219 00:00:53
220 00:00:59
221 00:03:00
222 00:04:00
223 00:09:09
224 00:13:13
225 00:51:51
226 00:54:54
227 01:01:01
228 02:02:02
229 03:03:00
230 08:08:08
231 100:04:04
232 11:11:11
233 11:11:27
234 125:00:00
235 125:05:00
236 12:12:12
237 12:34:56
238 150:00:00
239 22:22:22
240 838:00:00
241 838:56:00
242 838:58:00
243 838:59:51
244 838:59:52
245 838:59:55
246 838:59:57
247 838:59:58
248 838:59:59
249 SELECT c1 FROM t2 WHERE c1='-838:59:59' AND c2='-838:59:59';
250 c1
251 -838:59:59
252 UPDATE t2 SET c1='22:22:22' WHERE c1='-838:59:59' AND c2='-838:59:59';
253 SELECT c1 FROM t2;
254 c1
255 -838:59:55
256 00:00:00
257 00:00:01
258 00:00:04
259 00:00:07
260 00:00:08
261 00:00:09
262 00:00:10
263 00:00:11
264 00:00:12
265 00:00:14
266 00:00:50
267 00:00:53
268 00:00:59
269 00:03:00
270 00:04:00
271 00:09:09
272 00:13:13
273 00:51:51
274 00:54:54
275 01:01:01
276 02:02:02
277 03:03:00
278 08:08:08
279 100:04:04
280 11:11:11
281 11:11:27
282 125:00:00
283 125:05:00
284 12:12:12
285 150:00:00
286 22:22:22
287 838:00:00
288 838:56:00
289 838:58:00
290 838:59:51
291 838:59:52
292 838:59:55
293 838:59:57
294 838:59:58
295 838:59:59
296 SELECT c2 FROM t3 WHERE c2=null;
297 c2
298 UPDATE t3 SET c2='34 22:59:59' WHERE c2=null;
299 SELECT c2 FROM t3;
300 c2
301 -838:59:55
302 -838:59:59
303 00:00:00
304 00:00:01
305 00:00:04
306 00:00:07
307 00:00:08
308 00:00:09
309 00:00:10
310 00:00:11
311 00:00:12
312 00:00:14
313 00:00:50
314 00:00:53
315 00:00:59
316 00:03:00
317 00:04:00
318 00:09:09
319 00:13:13
320 00:51:51
321 00:54:54
322 01:01:01
323 02:02:02
324 03:03:00
325 08:08:08
326 100:04:04
327 11:11:11
328 11:11:27
329 125:00:00
330 125:05:00
331 12:12:12
332 150:00:00
333 838:00:00
334 838:56:00
335 838:58:00
336 838:59:51
337 838:59:52
338 838:59:55
339 838:59:57
340 838:59:58
341 838:59:59
342 NULL
343 SELECT c2 FROM t4 WHERE c1='00:00:00';
344 c2
345 00:00:00
346 UPDATE t4 SET c2=null WHERE c1='00:00:00';
347 SELECT c2 FROM t4;
348 c2
349 -838:59:55
350 -838:59:59
351 00:00:01
352 00:00:04
353 00:00:07
354 00:00:08
355 00:00:09
356 00:00:10
357 00:00:11
358 00:00:12
359 00:00:14
360 00:00:50
361 00:00:53
362 00:00:59
363 00:03:00
364 00:04:00
365 00:09:09
366 00:13:13
367 00:51:51
368 00:54:54
369 01:01:01
370 02:02:02
371 03:03:00
372 08:08:08
373 100:04:04
374 11:11:11
375 11:11:27
376 125:00:00
377 125:05:00
378 12:12:12
379 150:00:00
380 838:00:00
381 838:56:00
382 838:58:00
383 838:59:51
384 838:59:52
385 838:59:55
386 838:59:57
387 838:59:58
388 838:59:59
389 NULL
390 NULL
391 SELECT c1 FROM t4 WHERE c1 < '000009';
392 c1
393 -838:59:55
394 -838:59:59
395 00:00:00
396 00:00:01
397 00:00:04
398 00:00:07
399 00:00:08
400 UPDATE t4 SET c1='0101' WHERE c1 < '000009' ORDER BY c1 LIMIT 3;
401 SELECT c1 FROM t4;
402 c1
403 00:00:01
404 00:00:04
405 00:00:07
406 00:00:08
407 00:00:09
408 00:00:10
409 00:00:11
410 00:00:12
411 00:00:14
412 00:00:50
413 00:00:53
414 00:00:59
415 00:01:01
416 00:01:01
417 00:01:01
418 00:03:00
419 00:04:00
420 00:09:09
421 00:13:13
422 00:51:51
423 00:54:54
424 01:01:01
425 02:02:02
426 03:03:00
427 08:08:08
428 100:04:04
429 11:11:11
430 11:11:27
431 125:00:00
432 125:05:00
433 12:12:12
434 12:34:56
435 150:00:00
436 838:00:00
437 838:56:00
438 838:58:00
439 838:59:51
440 838:59:52
441 838:59:55
442 838:59:57
443 838:59:58
444 838:59:59
445 SELECT c1 FROM t1 WHERE c1='12:12:12';
446 c1
447 12:12:12
448 UPDATE t1 SET c1='-12:12:12' WHERE c1='12:12:12';
449 SELECT c1 FROM t1;
450 c1
451 -12:12:12
452 -838:59:55
453 -838:59:59
454 00:00:00
455 00:00:01
456 00:00:04
457 00:00:08
458 00:00:09
459 00:00:10
460 00:00:11
461 00:00:12
462 00:00:14
463 00:00:50
464 00:00:53
465 00:00:59
466 00:03:00
467 00:04:00
468 00:09:09
469 00:13:13
470 00:51:51
471 00:54:54
472 01:01:01
473 02:02:02
474 03:03:00
475 08:08:08
476 100:04:04
477 11:11:11
478 11:11:27
479 125:00:00
480 125:05:00
481 12:34:56
482 150:00:00
483 22:22:22
484 838:00:00
485 838:56:00
486 838:58:00
487 838:59:51
488 838:59:52
489 838:59:55
490 838:59:57
491 838:59:58
492 838:59:59
493 SELECT c1 FROM t1 WHERE c1=111127;
494 c1
495 11:11:27
496 UPDATE t1 SET c1=c1+c2 WHERE c1=111127;
497 SELECT c1 FROM t1;
498 c1
499 -12:12:12
500 -838:59:55
501 -838:59:59
502 00:00:00
503 00:00:01
504 00:00:04
505 00:00:08
506 00:00:09
507 00:00:10
508 00:00:11
509 00:00:12
510 00:00:14
511 00:00:50
512 00:00:53
513 00:00:59
514 00:03:00
515 00:04:00
516 00:09:09
517 00:13:13
518 00:51:51
519 00:54:54
520 01:01:01
521 02:02:02
522 03:03:00
523 08:08:08
524 100:04:04
525 11:11:11
526 125:00:00
527 125:05:00
528 12:34:56
529 150:00:00
530 22:22:22
531 22:22:54
532 838:00:00
533 838:56:00
534 838:58:00
535 838:59:51
536 838:59:52
537 838:59:55
538 838:59:57
539 838:59:58
540 838:59:59
541 SELECT c1 FROM t2 WHERE c2='100:04:04';
542 c1
543 100:04:04
544 UPDATE t2 SET c1=c1 - '010101' WHERE c2=1000404;
545 SELECT c1 FROM t2;
546 c1
547 -838:59:55
548 00:00:00
549 00:00:01
550 00:00:04
551 00:00:07
552 00:00:08
553 00:00:09
554 00:00:10
555 00:00:11
556 00:00:12
557 00:00:14
558 00:00:50
559 00:00:53
560 00:00:59
561 00:03:00
562 00:04:00
563 00:09:09
564 00:13:13
565 00:51:51
566 00:54:54
567 01:01:01
568 02:02:02
569 03:03:00
570 08:08:08
571 11:11:11
572 11:11:27
573 125:00:00
574 125:05:00
575 12:12:12
576 150:00:00
577 22:22:22
578 838:00:00
579 838:56:00
580 838:58:00
581 838:59:51
582 838:59:52
583 838:59:55
584 838:59:57
585 838:59:58
586 838:59:59
587 99:03:03
588 SELECT c2 FROM t3 WHERE c2=020202;
589 c2
590 02:02:02
591 UPDATE t3 SET c2=c1 * 2 WHERE c2='020202';
592 SELECT c1 FROM t3;
593 c1
594 -838:59:55
595 -838:59:59
596 00:00:00
597 00:00:01
598 00:00:04
599 00:00:07
600 00:00:08
601 00:00:09
602 00:00:10
603 00:00:11
604 00:00:12
605 00:00:14
606 00:00:50
607 00:00:53
608 00:00:59
609 00:03:00
610 00:04:00
611 00:09:09
612 00:13:13
613 00:51:51
614 00:54:54
615 01:01:01
616 02:02:02
617 03:03:00
618 08:08:08
619 100:04:04
620 11:11:11
621 11:11:27
622 125:00:00
623 125:05:00
624 12:12:12
625 12:34:56
626 150:00:00
627 838:00:00
628 838:56:00
629 838:58:00
630 838:59:51
631 838:59:52
632 838:59:55
633 838:59:57
634 838:59:58
635 838:59:59
636 SELECT c1 FROM t4 WHERE c1=121212;
637 c1
638 12:12:12
639 UPDATE t4 SET c1=c1 / 2 WHERE c1='12:12:12';
640 SELECT c1 FROM t4;
641 c1
642 00:00:01
643 00:00:04
644 00:00:07
645 00:00:08
646 00:00:09
647 00:00:10
648 00:00:11
649 00:00:12
650 00:00:14
651 00:00:50
652 00:00:53
653 00:00:59
654 00:01:01
655 00:01:01
656 00:01:01
657 00:03:00
658 00:04:00
659 00:09:09
660 00:13:13
661 00:51:51
662 00:54:54
663 01:01:01
664 02:02:02
665 03:03:00
666 06:06:06
667 08:08:08
668 100:04:04
669 11:11:11
670 11:11:27
671 125:00:00
672 125:05:00
673 12:34:56
674 150:00:00
675 838:00:00
676 838:56:00
677 838:58:00
678 838:59:51
679 838:59:52
680 838:59:55
681 838:59:57
682 838:59:58
683 838:59:59
684 UPDATE t1 SET c2=1250000 WHERE c1='00:00:09' AND c1='01:01:01';
685 SELECT c2 FROM t1;
686 c2
687 -838:59:55
688 -838:59:59
689 00:00:00
690 00:00:01
691 00:00:04
692 00:00:07
693 00:00:08
694 00:00:09
695 00:00:10
696 00:00:11
697 00:00:12
698 00:00:14
699 00:00:50
700 00:00:53
701 00:00:59
702 00:03:00
703 00:04:00
704 00:09:09
705 00:13:13
706 00:51:51
707 00:54:54
708 01:01:01
709 02:02:02
710 03:03:00
711 08:08:08
712 100:04:04
713 11:11:11
714 11:11:27
715 125:00:00
716 125:05:00
717 12:12:12
718 150:00:00
719 838:00:00
720 838:56:00
721 838:58:00
722 838:59:51
723 838:59:52
724 838:59:55
725 838:59:57
726 838:59:58
727 838:59:59
728 NULL
729 UPDATE t2 SET c1=125959 WHERE c2=000400 OR c2= 000900;
730 SELECT c1 FROM t2;
731 c1
732 -838:59:55
733 00:00:00
734 00:00:01
735 00:00:04
736 00:00:07
737 00:00:08
738 00:00:09
739 00:00:10
740 00:00:11
741 00:00:12
742 00:00:14
743 00:00:50
744 00:00:53
745 00:00:59
746 00:03:00
747 00:09:09
748 00:13:13
749 00:51:51
750 00:54:54
751 01:01:01
752 02:02:02
753 03:03:00
754 08:08:08
755 11:11:11
756 11:11:27
757 125:00:00
758 125:05:00
759 12:12:12
760 12:59:59
761 150:00:00
762 22:22:22
763 838:00:00
764 838:56:00
765 838:58:00
766 838:59:51
767 838:59:52
768 838:59:55
769 838:59:57
770 838:59:58
771 838:59:59
772 99:03:03
773 UPDATE t2 SET c2='1111' WHERE c1 IN ('100:04:04',005454,'2:2:2',111111);
774 SELECT c2 FROM t2;
775 c2
776 -838:59:55
777 -838:59:59
778 00:00:00
779 00:00:01
780 00:00:04
781 00:00:07
782 00:00:08
783 00:00:09
784 00:00:10
785 00:00:11
786 00:00:12
787 00:00:14
788 00:00:50
789 00:00:53
790 00:00:59
791 00:03:00
792 00:04:00
793 00:09:09
794 00:11:11
795 00:11:11
796 00:11:11
797 00:13:13
798 00:51:51
799 01:01:01
800 03:03:00
801 08:08:08
802 100:04:04
803 11:11:27
804 125:00:00
805 125:05:00
806 12:12:12
807 150:00:00
808 838:00:00
809 838:56:00
810 838:58:00
811 838:59:51
812 838:59:52
813 838:59:55
814 838:59:57
815 838:59:58
816 838:59:59
817 UPDATE IGNORE t4 SET c2='-838:59:60' WHERE c1='100:04:04';
818 Warnings:
819 Warning 1265 Data truncated for column 'c2' at row 12
820 SELECT c2 FROM t4;
821 c2
822 -838:59:55
823 -838:59:59
824 00:00:00
825 00:00:01
826 00:00:04
827 00:00:07
828 00:00:08
829 00:00:09
830 00:00:10
831 00:00:11
832 00:00:12
833 00:00:14
834 00:00:50
835 00:00:53
836 00:00:59
837 00:03:00
838 00:04:00
839 00:09:09
840 00:13:13
841 00:51:51
842 00:54:54
843 01:01:01
844 02:02:02
845 03:03:00
846 08:08:08
847 11:11:11
848 11:11:27
849 125:00:00
850 125:05:00
851 12:12:12
852 150:00:00
853 838:00:00
854 838:56:00
855 838:58:00
856 838:59:51
857 838:59:52
858 838:59:55
859 838:59:57
860 838:59:58
861 838:59:59
862 NULL
863 NULL
864 UPDATE IGNORE t4 SET c2='838:59:60' WHERE c1='100:04:04';
865 Warnings:
866 Warning 1265 Data truncated for column 'c2' at row 12
867 SELECT c2 FROM t4;
868 c2
869 -838:59:55
870 -838:59:59
871 00:00:00
872 00:00:01
873 00:00:04
874 00:00:07
875 00:00:08
876 00:00:09
877 00:00:10
878 00:00:11
879 00:00:12
880 00:00:14
881 00:00:50
882 00:00:53
883 00:00:59
884 00:03:00
885 00:04:00
886 00:09:09
887 00:13:13
888 00:51:51
889 00:54:54
890 01:01:01
891 02:02:02
892 03:03:00
893 08:08:08
894 11:11:11
895 11:11:27
896 125:00:00
897 125:05:00
898 12:12:12
899 150:00:00
900 838:00:00
901 838:56:00
902 838:58:00
903 838:59:51
904 838:59:52
905 838:59:55
906 838:59:57
907 838:59:58
908 838:59:59
909 NULL
910 NULL
911 UPDATE t4 SET c2='00:00:00' WHERE c1='100:04:04';
912 SELECT c2 FROM t4;
913 c2
914 -838:59:55
915 -838:59:59
916 00:00:00
917 00:00:01
918 00:00:04
919 00:00:07
920 00:00:08
921 00:00:09
922 00:00:10
923 00:00:11
924 00:00:12
925 00:00:14
926 00:00:50
927 00:00:53
928 00:00:59
929 00:03:00
930 00:04:00
931 00:09:09
932 00:13:13
933 00:51:51
934 00:54:54
935 01:01:01
936 02:02:02
937 03:03:00
938 08:08:08
939 11:11:11
940 11:11:27
941 125:00:00
942 125:05:00
943 12:12:12
944 150:00:00
945 838:00:00
946 838:56:00
947 838:58:00
948 838:59:51
949 838:59:52
950 838:59:55
951 838:59:57
952 838:59:58
953 838:59:59
954 NULL
955 NULL
956 UPDATE IGNORE t4 SET c2='11:11:60' WHERE c1='100:04:04';
957 Warnings:
958 Warning 1265 Data truncated for column 'c2' at row 12
959 SELECT c2 FROM t4;
960 c2
961 -838:59:55
962 -838:59:59
963 00:00:00
964 00:00:01
965 00:00:04
966 00:00:07
967 00:00:08
968 00:00:09
969 00:00:10
970 00:00:11
971 00:00:12
972 00:00:14
973 00:00:50
974 00:00:53
975 00:00:59
976 00:03:00
977 00:04:00
978 00:09:09
979 00:13:13
980 00:51:51
981 00:54:54
982 01:01:01
983 02:02:02
984 03:03:00
985 08:08:08
986 11:11:11
987 11:11:27
988 125:00:00
989 125:05:00
990 12:12:12
991 150:00:00
992 838:00:00
993 838:56:00
994 838:58:00
995 838:59:51
996 838:59:52
997 838:59:55
998 838:59:57
999 838:59:58
1000 838:59:59
1001 NULL
1002 NULL
1003 UPDATE IGNORE t4 SET c2='11:60:11' WHERE c1='100:04:04';
1004 Warnings:
1005 Warning 1265 Data truncated for column 'c2' at row 12
1006 SELECT c2 FROM t4;
1007 c2
1008 -838:59:55
1009 -838:59:59
1010 00:00:00
1011 00:00:01
1012 00:00:04
1013 00:00:07
1014 00:00:08
1015 00:00:09
1016 00:00:10
1017 00:00:11
1018 00:00:12
1019 00:00:14
1020 00:00:50
1021 00:00:53
1022 00:00:59
1023 00:03:00
1024 00:04:00
1025 00:09:09
1026 00:13:13
1027 00:51:51
1028 00:54:54
1029 01:01:01
1030 02:02:02
1031 03:03:00
1032 08:08:08
1033 11:11:11
1034 11:11:27
1035 125:00:00
1036 125:05:00
1037 12:12:12
1038 150:00:00
1039 838:00:00
1040 838:56:00
1041 838:58:00
1042 838:59:51
1043 838:59:52
1044 838:59:55
1045 838:59:57
1046 838:59:58
1047 838:59:59
1048 NULL
1049 NULL
1050 SELECT c1 FROM t3 WHERE c2 < '000007';
1051 c1
1052 -838:59:55
1053 -838:59:59
1054 00:00:00
1055 00:00:01
1056 00:00:04
1057 SET SQL_MODE=STRICT_ALL_TABLES;
1058 UPDATE t3 SET c1=NULL WHERE c2 < '000007';
1059 ERROR 23000: Column 'c1' cannot be null
1060 UPDATE IGNORE t3 SET c1=NULL WHERE c2 < '000007';
1061 Warnings:
1062 Warning 1048 Column 'c1' cannot be null
1063 Warning 1048 Column 'c1' cannot be null
1064 Warning 1048 Column 'c1' cannot be null
1065 Warning 1048 Column 'c1' cannot be null
1066 Warning 1048 Column 'c1' cannot be null
1067 SELECT c1 from t3 WHERE c2 < '000007';
1068 c1
1069 00:00:00
1070 00:00:00
1071 00:00:00
1072 00:00:00
1073 00:00:00
1074 SET SQL_MODE=DEFAULT;
1075 UPDATE t1 SET c1=8385958 WHERE c2='34 22:59:59';
1076 ERROR 23000: Duplicate entry '838:59:58' for key 'PRIMARY'
1077 UPDATE IGNORE t1 SET c2='def' WHERE c1=59;
1078 Warnings:
1079 Warning 1265 Data truncated for column 'c2' at row 1
1080 SELECT c2 FROM t1;
1081 c2
1082 -838:59:55
1083 -838:59:59
1084 00:00:00
1085 00:00:00
1086 00:00:01
1087 00:00:04
1088 00:00:07
1089 00:00:08
1090 00:00:09
1091 00:00:10
1092 00:00:11
1093 00:00:12
1094 00:00:14
1095 00:00:50
1096 00:00:53
1097 00:03:00
1098 00:04:00
1099 00:09:09
1100 00:13:13
1101 00:51:51
1102 00:54:54
1103 01:01:01
1104 02:02:02
1105 03:03:00
1106 08:08:08
1107 100:04:04
1108 11:11:11
1109 11:11:27
1110 125:00:00
1111 125:05:00
1112 12:12:12
1113 150:00:00
1114 838:00:00
1115 838:56:00
1116 838:58:00
1117 838:59:51
1118 838:59:52
1119 838:59:55
1120 838:59:57
1121 838:59:58
1122 838:59:59
1123 NULL
1124 UPDATE t4 SET c1=11:11:11 WHERE c2=NULL;
1125 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':11:11 WHERE c2=NULL' at line 1
1126 SELECT c1 FROM t4;
1127 c1
1128 00:00:01
1129 00:00:04
1130 00:00:07
1131 00:00:08
1132 00:00:09
1133 00:00:10
1134 00:00:11
1135 00:00:12
1136 00:00:14
1137 00:00:50
1138 00:00:53
1139 00:00:59
1140 00:01:01
1141 00:01:01
1142 00:01:01
1143 00:03:00
1144 00:04:00
1145 00:09:09
1146 00:13:13
1147 00:51:51
1148 00:54:54
1149 01:01:01
1150 02:02:02
1151 03:03:00
1152 06:06:06
1153 08:08:08
1154 100:04:04
1155 11:11:11
1156 11:11:27
1157 125:00:00
1158 125:05:00
1159 12:34:56
1160 150:00:00
1161 838:00:00
1162 838:56:00
1163 838:58:00
1164 838:59:51
1165 838:59:52
1166 838:59:55
1167 838:59:57
1168 838:59:58
1169 838:59:59
1170 UPDATE t1,t2,t3,t4 SET t1.c2=t2.c1+t2.c2,t3.c2=t4.c1*2 WHERE t1.c1='00:13:13' AND t2.c1=080808 AND t4.c1='00:04:00' AND t3.c2=020202;
1171 UPDATE t1 SET t1.c1='00:12:12' WHERE c1='00:09:09' AND c2='00:09:09';
1172 SELECT * FROM t1;
1173 c1 c2
1174 -12:12:12 12:12:12
1175 -838:59:55 -838:59:55
1176 -838:59:59 -838:59:59
1177 00:00:00 00:00:00
1178 00:00:01 00:00:01
1179 00:00:04 00:00:04
1180 00:00:08 00:00:08
1181 00:00:09 00:00:09
1182 00:00:10 00:00:10
1183 00:00:11 00:00:11
1184 00:00:12 00:00:12
1185 00:00:14 00:00:14
1186 00:00:50 00:00:50
1187 00:00:53 00:00:53
1188 00:00:59 00:00:00
1189 00:03:00 00:03:00
1190 00:04:00 00:04:00
1191 00:12:12 00:09:09
1192 00:13:13 00:13:13
1193 00:51:51 00:51:51
1194 00:54:54 00:54:54
1195 01:01:01 01:01:01
1196 02:02:02 02:02:02
1197 03:03:00 03:03:00
1198 08:08:08 08:08:08
1199 100:04:04 100:04:04
1200 11:11:11 11:11:11
1201 125:00:00 125:00:00
1202 125:05:00 125:05:00
1203 12:34:56 NULL
1204 150:00:00 150:00:00
1205 22:22:22 00:00:07
1206 22:22:54 11:11:27
1207 838:00:00 838:00:00
1208 838:56:00 838:56:00
1209 838:58:00 838:58:00
1210 838:59:51 838:59:51
1211 838:59:52 838:59:52
1212 838:59:55 838:59:55
1213 838:59:57 838:59:57
1214 838:59:58 838:59:58
1215 838:59:59 838:59:59
1216 UPDATE IGNORE t1 SET t1.c2='99999.99999' WHERE c1 BETWEEN 080000 AND 100000;
1217 Warnings:
1218 Warning 1265 Data truncated for column 'c2' at row N
1219 SELECT * FROM t1;
1220 c1 c2
1221 -12:12:12 12:12:12
1222 -838:59:55 -838:59:55
1223 -838:59:59 -838:59:59
1224 00:00:00 00:00:00
1225 00:00:01 00:00:01
1226 00:00:04 00:00:04
1227 00:00:08 00:00:08
1228 00:00:09 00:00:09
1229 00:00:10 00:00:10
1230 00:00:11 00:00:11
1231 00:00:12 00:00:12
1232 00:00:14 00:00:14
1233 00:00:50 00:00:50
1234 00:00:53 00:00:53
1235 00:00:59 00:00:00
1236 00:03:00 00:03:00
1237 00:04:00 00:04:00
1238 00:12:12 00:09:09
1239 00:13:13 00:13:13
1240 00:51:51 00:51:51
1241 00:54:54 00:54:54
1242 01:01:01 01:01:01
1243 02:02:02 02:02:02
1244 03:03:00 03:03:00
1245 08:08:08 00:00:00
1246 100:04:04 100:04:04
1247 11:11:11 11:11:11
1248 125:00:00 125:00:00
1249 125:05:00 125:05:00
1250 12:34:56 NULL
1251 150:00:00 150:00:00
1252 22:22:22 00:00:07
1253 22:22:54 11:11:27
1254 838:00:00 838:00:00
1255 838:56:00 838:56:00
1256 838:58:00 838:58:00
1257 838:59:51 838:59:51
1258 838:59:52 838:59:52
1259 838:59:55 838:59:55
1260 838:59:57 838:59:57
1261 838:59:58 838:59:58
1262 838:59:59 838:59:59
1263 UPDATE IGNORE t1 SET c1=c1+1,c2=c2-1 WHERE c1 IN (222222,8385955,1500000) ORDER BY c1;
1264 Warnings:
1265 Warning 1265 Data truncated for column 'c2' at row 2
1266 SELECT * FROM t1;
1267 c1 c2
1268 -12:12:12 12:12:12
1269 -838:59:55 -838:59:55
1270 -838:59:59 -838:59:59
1271 00:00:00 00:00:00
1272 00:00:01 00:00:01
1273 00:00:04 00:00:04
1274 00:00:08 00:00:08
1275 00:00:09 00:00:09
1276 00:00:10 00:00:10
1277 00:00:11 00:00:11
1278 00:00:12 00:00:12
1279 00:00:14 00:00:14
1280 00:00:50 00:00:50
1281 00:00:53 00:00:53
1282 00:00:59 00:00:00
1283 00:03:00 00:03:00
1284 00:04:00 00:04:00
1285 00:12:12 00:09:09
1286 00:13:13 00:13:13
1287 00:51:51 00:51:51
1288 00:54:54 00:54:54
1289 01:01:01 01:01:01
1290 02:02:02 02:02:02
1291 03:03:00 03:03:00
1292 08:08:08 00:00:00
1293 100:04:04 100:04:04
1294 11:11:11 11:11:11
1295 125:00:00 125:00:00
1296 125:05:00 125:05:00
1297 12:34:56 NULL
1298 150:00:01 00:00:00
1299 22:22:23 00:00:06
1300 22:22:54 11:11:27
1301 838:00:00 838:00:00
1302 838:56:00 838:56:00
1303 838:58:00 838:58:00
1304 838:59:51 838:59:51
1305 838:59:52 838:59:52
1306 838:59:56 838:59:54
1307 838:59:57 838:59:57
1308 838:59:58 838:59:58
1309 838:59:59 838:59:59
1310 UPDATE t1,t2 SET t1.c2='22222.22222' WHERE t1.c1=t2.c1 AND t1.c2=t2.c2;
1311 SELECT * FROM t1;
1312 c1 c2
1313 -12:12:12 12:12:12
1314 -838:59:55 02:22:22
1315 -838:59:59 -838:59:59
1316 00:00:00 02:22:22
1317 00:00:01 02:22:22
1318 00:00:04 02:22:22
1319 00:00:08 02:22:22
1320 00:00:09 02:22:22
1321 00:00:10 02:22:22
1322 00:00:11 02:22:22
1323 00:00:12 02:22:22
1324 00:00:14 02:22:22
1325 00:00:50 02:22:22
1326 00:00:53 02:22:22
1327 00:00:59 00:00:00
1328 00:03:00 02:22:22
1329 00:04:00 00:04:00
1330 00:12:12 00:09:09
1331 00:13:13 02:22:22
1332 00:51:51 02:22:22
1333 00:54:54 00:54:54
1334 01:01:01 02:22:22
1335 02:02:02 02:02:02
1336 03:03:00 02:22:22
1337 08:08:08 00:00:00
1338 100:04:04 100:04:04
1339 11:11:11 11:11:11
1340 125:00:00 02:22:22
1341 125:05:00 02:22:22
1342 12:34:56 NULL
1343 150:00:01 00:00:00
1344 22:22:23 00:00:06
1345 22:22:54 11:11:27
1346 838:00:00 02:22:22
1347 838:56:00 02:22:22
1348 838:58:00 02:22:22
1349 838:59:51 02:22:22
1350 838:59:52 02:22:22
1351 838:59:56 838:59:54
1352 838:59:57 02:22:22
1353 838:59:58 02:22:22
1354 838:59:59 02:22:22
1355 SELECT * FROM t2;
1356 c1 c2
1357 -838:59:55 -838:59:55
1358 00:00:00 00:00:00
1359 00:00:01 00:00:01
1360 00:00:04 00:00:04
1361 00:00:07 00:00:07
1362 00:00:08 00:00:08
1363 00:00:09 00:00:09
1364 00:00:10 00:00:10
1365 00:00:11 00:00:11
1366 00:00:12 00:00:12
1367 00:00:14 00:00:14
1368 00:00:50 00:00:50
1369 00:00:53 00:00:53
1370 00:00:59 00:00:59
1371 00:03:00 00:03:00
1372 00:09:09 00:09:09
1373 00:13:13 00:13:13
1374 00:51:51 00:51:51
1375 00:54:54 00:11:11
1376 01:01:01 01:01:01
1377 02:02:02 00:11:11
1378 03:03:00 03:03:00
1379 08:08:08 08:08:08
1380 11:11:11 00:11:11
1381 11:11:27 11:11:27
1382 125:00:00 125:00:00
1383 125:05:00 125:05:00
1384 12:12:12 12:12:12
1385 12:59:59 00:04:00
1386 150:00:00 150:00:00
1387 22:22:22 -838:59:59
1388 838:00:00 838:00:00
1389 838:56:00 838:56:00
1390 838:58:00 838:58:00
1391 838:59:51 838:59:51
1392 838:59:52 838:59:52
1393 838:59:55 838:59:55
1394 838:59:57 838:59:57
1395 838:59:58 838:59:58
1396 838:59:59 838:59:59
1397 99:03:03 100:04:04
1398 SELECT * FROM t3;
1399 c1 c2
1400 00:00:00 -838:59:55
1401 00:00:00 -838:59:59
1402 00:00:00 00:00:00
1403 00:00:00 00:00:01
1404 00:00:00 00:00:04
1405 00:00:07 00:00:07
1406 00:00:08 00:00:08
1407 00:00:09 00:00:09
1408 00:00:10 00:00:10
1409 00:00:11 00:00:11
1410 00:00:12 00:00:12
1411 00:00:14 00:00:14
1412 00:00:50 00:00:50
1413 00:00:53 00:00:53
1414 00:00:59 00:00:59
1415 00:03:00 00:03:00
1416 00:04:00 00:04:00
1417 00:09:09 00:09:09
1418 00:13:13 00:13:13
1419 00:51:51 00:51:51
1420 00:54:54 00:54:54
1421 01:01:01 01:01:01
1422 02:02:02 04:04:04
1423 03:03:00 03:03:00
1424 08:08:08 08:08:08
1425 100:04:04 100:04:04
1426 11:11:11 11:11:11
1427 11:11:27 11:11:27
1428 125:00:00 125:00:00
1429 125:05:00 125:05:00
1430 12:12:12 12:12:12
1431 12:34:56 NULL
1432 150:00:00 150:00:00
1433 838:00:00 838:00:00
1434 838:56:00 838:56:00
1435 838:58:00 838:58:00
1436 838:59:51 838:59:51
1437 838:59:52 838:59:52
1438 838:59:55 838:59:55
1439 838:59:57 838:59:57
1440 838:59:58 838:59:58
1441 838:59:59 838:59:59
1442 SELECT * FROM t4;
1443 c1 c2
1444 00:00:01 00:00:01
1445 00:00:04 00:00:04
1446 00:00:07 00:00:07
1447 00:00:08 00:00:08
1448 00:00:09 00:00:09
1449 00:00:10 00:00:10
1450 00:00:11 00:00:11
1451 00:00:12 00:00:12
1452 00:00:14 00:00:14
1453 00:00:50 00:00:50
1454 00:00:53 00:00:53
1455 00:00:59 00:00:59
1456 00:01:01 -838:59:55
1457 00:01:01 -838:59:59
1458 00:01:01 NULL
1459 00:03:00 00:03:00
1460 00:04:00 00:04:00
1461 00:09:09 00:09:09
1462 00:13:13 00:13:13
1463 00:51:51 00:51:51
1464 00:54:54 00:54:54
1465 01:01:01 01:01:01
1466 02:02:02 02:02:02
1467 03:03:00 03:03:00
1468 06:06:06 12:12:12
1469 08:08:08 08:08:08
1470 100:04:04 00:00:00
1471 11:11:11 11:11:11
1472 11:11:27 11:11:27
1473 125:00:00 125:00:00
1474 125:05:00 125:05:00
1475 12:34:56 NULL
1476 150:00:00 150:00:00
1477 838:00:00 838:00:00
1478 838:56:00 838:56:00
1479 838:58:00 838:58:00
1480 838:59:51 838:59:51
1481 838:59:52 838:59:52
1482 838:59:55 838:59:55
1483 838:59:57 838:59:57
1484 838:59:58 838:59:58
1485 838:59:59 838:59:59
1486 DROP TABLE IF EXISTS t1,t2,t3,t4;