Debian Codegraph @

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

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