Debian Codegraph @

mysql-test/suite/engines/iuds/r/delete_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 NOT 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 DELETE FROM t1 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 838:00:00
240 838:56:00
241 838:58:00
242 838:59:51
243 838:59:52
244 838:59:55
245 838:59:57
246 838:59:58
247 838:59:59
248 SELECT c1 FROM t2 WHERE c1='-838:59:59' AND c2='-838:59:59';
249 c1
250 -838:59:59
251 DELETE FROM t2 WHERE c1='-838:59:59' AND c2='-838:59:59';
252 SELECT c1 FROM t2;
253 c1
254 -838:59:55
255 00:00:00
256 00:00:01
257 00:00:04
258 00:00:07
259 00:00:08
260 00:00:09
261 00:00:10
262 00:00:11
263 00:00:12
264 00:00:14
265 00:00:50
266 00:00:53
267 00:00:59
268 00:03:00
269 00:04:00
270 00:09:09
271 00:13:13
272 00:51:51
273 00:54:54
274 01:01:01
275 02:02:02
276 03:03:00
277 08:08:08
278 100:04:04
279 11:11:11
280 11:11:27
281 125:00:00
282 125:05:00
283 12:12:12
284 150:00:00
285 838:00:00
286 838:56:00
287 838:58:00
288 838:59:51
289 838:59:52
290 838:59:55
291 838:59:57
292 838:59:58
293 838:59:59
294 SELECT c2 FROM t3 WHERE c2=null;
295 c2
296 DELETE FROM t3 WHERE c2=null;
297 SELECT c2 FROM t3;
298 c2
299 -838:59:55
300 -838:59:59
301 00:00:00
302 00:00:01
303 00:00:04
304 00:00:07
305 00:00:08
306 00:00:09
307 00:00:10
308 00:00:11
309 00:00:12
310 00:00:14
311 00:00:50
312 00:00:53
313 00:00:59
314 00:03:00
315 00:04:00
316 00:09:09
317 00:13:13
318 00:51:51
319 00:54:54
320 01:01:01
321 02:02:02
322 03:03:00
323 08:08:08
324 100:04:04
325 11:11:11
326 11:11:27
327 125:00:00
328 125:05:00
329 12:12:12
330 150:00:00
331 838:00:00
332 838:56:00
333 838:58:00
334 838:59:51
335 838:59:52
336 838:59:55
337 838:59:57
338 838:59:58
339 838:59:59
340 NULL
341 SELECT c1 FROM t4 WHERE c1 < '000009';
342 c1
343 -838:59:55
344 -838:59:59
345 00:00:00
346 00:00:01
347 00:00:04
348 00:00:07
349 00:00:08
350 DELETE FROM t4 WHERE c1 < '000009' ORDER BY c1 LIMIT 3;
351 SELECT c1 FROM t4;
352 c1
353 00:00:01
354 00:00:04
355 00:00:07
356 00:00:08
357 00:00:09
358 00:00:10
359 00:00:11
360 00:00:12
361 00:00:14
362 00:00:50
363 00:00:53
364 00:00:59
365 00:03:00
366 00:04:00
367 00:09:09
368 00:13:13
369 00:51:51
370 00:54:54
371 01:01:01
372 02:02:02
373 03:03:00
374 08:08:08
375 100:04:04
376 11:11:11
377 11:11:27
378 125:00:00
379 125:05:00
380 12:12:12
381 12:34:56
382 150:00:00
383 838:00:00
384 838:56:00
385 838:58:00
386 838:59:51
387 838:59:52
388 838:59:55
389 838:59:57
390 838:59:58
391 838:59:59
392 DELETE FROM t1 WHERE c1='00:00:09' AND c1='01:01:01';
393 SELECT c2 FROM t1;
394 c2
395 -838:59:55
396 -838:59:59
397 00:00:00
398 00:00:01
399 00:00:04
400 00:00:08
401 00:00:09
402 00:00:10
403 00:00:11
404 00:00:12
405 00:00:14
406 00:00:50
407 00:00:53
408 00:00:59
409 00:03:00
410 00:04:00
411 00:09:09
412 00:13:13
413 00:51:51
414 00:54:54
415 01:01:01
416 02:02:02
417 03:03:00
418 08:08:08
419 100:04:04
420 11:11:11
421 11:11:27
422 125:00:00
423 125:05:00
424 12:12:12
425 150:00:00
426 838:00:00
427 838:56:00
428 838:58:00
429 838:59:51
430 838:59:52
431 838:59:55
432 838:59:57
433 838:59:58
434 838:59:59
435 NULL
436 DELETE FROM t2 WHERE c2=000400 OR c2= 000900;
437 SELECT c1 FROM t2;
438 c1
439 -838:59:55
440 00:00:00
441 00:00:01
442 00:00:04
443 00:00:07
444 00:00:08
445 00:00:09
446 00:00:10
447 00:00:11
448 00:00:12
449 00:00:14
450 00:00:50
451 00:00:53
452 00:00:59
453 00:03:00
454 00:09:09
455 00:13:13
456 00:51:51
457 00:54:54
458 01:01:01
459 02:02:02
460 03:03:00
461 08:08:08
462 100:04:04
463 11:11:11
464 11:11:27
465 125:00:00
466 125:05:00
467 12:12:12
468 150:00:00
469 838:00:00
470 838:56:00
471 838:58:00
472 838:59:51
473 838:59:52
474 838:59:55
475 838:59:57
476 838:59:58
477 838:59:59
478 DELETE FROM t2 WHERE c1 IN ('100:04:04',005454,'2:2:2',111111) ORDER BY c1 LIMIT 2;
479 SELECT c2 FROM t2;
480 c2
481 -838:59:55
482 00:00:00
483 00:00:01
484 00:00:04
485 00:00:07
486 00:00:08
487 00:00:09
488 00:00:10
489 00:00:11
490 00:00:12
491 00:00:14
492 00:00:50
493 00:00:53
494 00:00:59
495 00:03:00
496 00:09:09
497 00:13:13
498 00:51:51
499 01:01:01
500 03:03:00
501 08:08:08
502 100:04:04
503 11:11:11
504 11:11:27
505 125:00:00
506 125:05:00
507 12:12:12
508 150:00:00
509 838:00:00
510 838:56:00
511 838:58:00
512 838:59:51
513 838:59:52
514 838:59:55
515 838:59:57
516 838:59:58
517 838:59:59
518 DELETE t1,t2,t3,t4 FROM t1,t2,t3,t4 WHERE t1.c1='00:13:13' AND t2.c1=080808 AND t4.c1='00:04:00' AND t3.c2=020202;
519 DELETE FROM t1 WHERE c1='00:09:09' AND c2='00:09:09';
520 SELECT * FROM t1;
521 c1 c2
522 -838:59:55 -838:59:55
523 -838:59:59 -838:59:59
524 00:00:00 00:00:00
525 00:00:01 00:00:01
526 00:00:04 00:00:04
527 00:00:08 00:00:08
528 00:00:09 00:00:09
529 00:00:10 00:00:10
530 00:00:11 00:00:11
531 00:00:12 00:00:12
532 00:00:14 00:00:14
533 00:00:50 00:00:50
534 00:00:53 00:00:53
535 00:00:59 00:00:59
536 00:03:00 00:03:00
537 00:04:00 00:04:00
538 00:51:51 00:51:51
539 00:54:54 00:54:54
540 01:01:01 01:01:01
541 02:02:02 02:02:02
542 03:03:00 03:03:00
543 08:08:08 08:08:08
544 100:04:04 100:04:04
545 11:11:11 11:11:11
546 11:11:27 11:11:27
547 125:00:00 125:00:00
548 125:05:00 125:05:00
549 12:12:12 12:12:12
550 12:34:56 NULL
551 150:00:00 150:00:00
552 838:00:00 838:00:00
553 838:56:00 838:56:00
554 838:58:00 838:58:00
555 838:59:51 838:59:51
556 838:59:52 838:59:52
557 838:59:55 838:59:55
558 838:59:57 838:59:57
559 838:59:58 838:59:58
560 838:59:59 838:59:59
561 DELETE FROM t1 WHERE c1 BETWEEN 080000 AND 100000;
562 SELECT * FROM t1;
563 c1 c2
564 -838:59:55 -838:59:55
565 -838:59:59 -838:59:59
566 00:00:00 00:00:00
567 00:00:01 00:00:01
568 00:00:04 00:00:04
569 00:00:08 00:00:08
570 00:00:09 00:00:09
571 00:00:10 00:00:10
572 00:00:11 00:00:11
573 00:00:12 00:00:12
574 00:00:14 00:00:14
575 00:00:50 00:00:50
576 00:00:53 00:00:53
577 00:00:59 00:00:59
578 00:03:00 00:03:00
579 00:04:00 00:04:00
580 00:51:51 00:51:51
581 00:54:54 00:54:54
582 01:01:01 01:01:01
583 02:02:02 02:02:02
584 03:03:00 03:03:00
585 100:04:04 100:04:04
586 11:11:11 11:11:11
587 11:11:27 11:11:27
588 125:00:00 125:00:00
589 125:05:00 125:05:00
590 12:12:12 12:12:12
591 12:34:56 NULL
592 150:00:00 150:00:00
593 838:00:00 838:00:00
594 838:56:00 838:56:00
595 838:58:00 838:58:00
596 838:59:51 838:59:51
597 838:59:52 838:59:52
598 838:59:55 838:59:55
599 838:59:57 838:59:57
600 838:59:58 838:59:58
601 838:59:59 838:59:59
602 DELETE FROM t1 WHERE c1 IN (222222,8385959,1500000);
603 SELECT * FROM t1;
604 c1 c2
605 -838:59:55 -838:59:55
606 -838:59:59 -838:59:59
607 00:00:00 00:00:00
608 00:00:01 00:00:01
609 00:00:04 00:00:04
610 00:00:08 00:00:08
611 00:00:09 00:00:09
612 00:00:10 00:00:10
613 00:00:11 00:00:11
614 00:00:12 00:00:12
615 00:00:14 00:00:14
616 00:00:50 00:00:50
617 00:00:53 00:00:53
618 00:00:59 00:00:59
619 00:03:00 00:03:00
620 00:04:00 00:04:00
621 00:51:51 00:51:51
622 00:54:54 00:54:54
623 01:01:01 01:01:01
624 02:02:02 02:02:02
625 03:03:00 03:03:00
626 100:04:04 100:04:04
627 11:11:11 11:11:11
628 11:11:27 11:11:27
629 125:00:00 125:00:00
630 125:05:00 125:05:00
631 12:12:12 12:12:12
632 12:34:56 NULL
633 838:00:00 838:00:00
634 838:56:00 838:56:00
635 838:58:00 838:58:00
636 838:59:51 838:59:51
637 838:59:52 838:59:52
638 838:59:55 838:59:55
639 838:59:57 838:59:57
640 838:59:58 838:59:58
641 DELETE t1,t2 FROM t1,t2 WHERE t1.c1=t2.c1 AND t1.c2=t2.c2;
642 SELECT * FROM t1;
643 c1 c2
644 -838:59:59 -838:59:59
645 00:04:00 00:04:00
646 00:54:54 00:54:54
647 02:02:02 02:02:02
648 12:34:56 NULL
649 SELECT * FROM t2;
650 c1 c2
651 00:00:07 00:00:07
652 00:09:09 00:09:09
653 00:13:13 00:13:13
654 150:00:00 150:00:00
655 838:59:59 838:59:59
656 SELECT * FROM t3;
657 c1 c2
658 -838:59:55 -838:59:55
659 -838:59:59 -838:59:59
660 00:00:00 00:00:00
661 00:00:01 00:00:01
662 00:00:04 00:00:04
663 00:00:07 00:00:07
664 00:00:08 00:00:08
665 00:00:09 00:00:09
666 00:00:10 00:00:10
667 00:00:11 00:00:11
668 00:00:12 00:00:12
669 00:00:14 00:00:14
670 00:00:50 00:00:50
671 00:00:53 00:00:53
672 00:00:59 00:00:59
673 00:03:00 00:03:00
674 00:04:00 00:04:00
675 00:09:09 00:09:09
676 00:13:13 00:13:13
677 00:51:51 00:51:51
678 00:54:54 00:54:54
679 01:01:01 01:01:01
680 03:03:00 03:03:00
681 08:08:08 08:08:08
682 100:04:04 100:04:04
683 11:11:11 11:11:11
684 11:11:27 11:11:27
685 125:00:00 125:00:00
686 125:05:00 125:05:00
687 12:12:12 12:12:12
688 12:34:56 NULL
689 150:00:00 150:00:00
690 838:00:00 838:00:00
691 838:56:00 838:56:00
692 838:58:00 838:58:00
693 838:59:51 838:59:51
694 838:59:52 838:59:52
695 838:59:55 838:59:55
696 838:59:57 838:59:57
697 838:59:58 838:59:58
698 838:59:59 838:59:59
699 SELECT * FROM t4;
700 c1 c2
701 00:00:01 00:00:01
702 00:00:04 00:00:04
703 00:00:07 00:00:07
704 00:00:08 00:00:08
705 00:00:09 00:00:09
706 00:00:10 00:00:10
707 00:00:11 00:00:11
708 00:00:12 00:00:12
709 00:00:14 00:00:14
710 00:00:50 00:00:50
711 00:00:53 00:00:53
712 00:00:59 00:00:59
713 00:03:00 00:03:00
714 00:09:09 00:09:09
715 00:13:13 00:13:13
716 00:51:51 00:51:51
717 00:54:54 00:54:54
718 01:01:01 01:01:01
719 02:02:02 02:02:02
720 03:03:00 03:03:00
721 08:08:08 08:08:08
722 100:04:04 100:04:04
723 11:11:11 11:11:11
724 11:11:27 11:11:27
725 125:00:00 125:00:00
726 125:05:00 125:05:00
727 12:12:12 12:12:12
728 12:34:56 NULL
729 150:00:00 150:00:00
730 838:00:00 838:00:00
731 838:56:00 838:56:00
732 838:58:00 838:58:00
733 838:59:51 838:59:51
734 838:59:52 838:59:52
735 838:59:55 838:59:55
736 838:59:57 838:59:57
737 838:59:58 838:59:58
738 838:59:59 838:59:59
739 DROP TABLE IF EXISTS t1,t2,t3,t4;