Eine aufbereitete Darstellung der Quelle

 
     
 
 
Anforderungen  |   Konzepte  |   Entwurf  |   Entwicklung  |   Qualitätssicherung  |   Lebenszyklus  |   Steuerung
 
 
 
 
Benutzer

products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/engines/iuds/r/   (MariaDB Server Version 8.1-8.4©)  Datei vom 1.9.2026 mit Größe 14 kB image not shown  

Quelle  delete_time.result   Sprache: Lisp

  

DROP TABLE IF EXISTS t1,t2,t3,t4;
CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, PRIMARY KEY(c1));
CREATE TABLE t2(c1 TIME NOT NULL, c2 TIME NULL, PRIMARY KEY(c1,c2));
CREATE TABLE t3(c1 TIME NOT NULL, c2 TIME NULL, UNIQUE INDEX idx(c1,c2));
CREATE TABLE t4(c1 TIME NOT NULL, c2 TIME NULL);
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');
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');
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');
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');
INSERT INTO t1 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53');
INSERT INTO t2 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53');
INSERT INTO t3 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53');
INSERT INTO t4 VALUES('000008','000008'),('080808','080808'),('8385955','8385955'),('-8385955','-8385955'),('0009','0009'),('0909','0909'),('5454','5454'),('10','10'),('53','53');
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);
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);
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);
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);
SET TIMESTAMP=1233216687;
INSERT INTO t1 VALUES(CURRENT_TIME(),CURRENT_TIME());
INSERT INTO t2 VALUES(CURRENT_TIME(),CURRENT_TIME());
INSERT INTO t3 VALUES(CURRENT_TIME(),CURRENT_TIME());
INSERT INTO t4 VALUES(CURRENT_TIME(),CURRENT_TIME());
INSERT INTO t1 VALUES('123456',null);
INSERT INTO t3 VALUES('123456',null);
INSERT INTO t4 VALUES('123456',null);
SELECT * FROM t1;
c1 c2
-838:59:55 -838:59:55
-838:59:59 -838:59:59
00:00:00 00:00:00
00:00:01 00:00:01
00:00:04 00:00:04
00:00:07 00:00:07
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:04:00 00:04:00
00:09:09 00:09:09
00:13:13 00:13:13
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
02:02:02 02:02:02
03:03:00 03:03:00
08:08:08 08:08:08
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
12:34:56 NULL
150:00:00 150:00:00
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
838:59:59 838:59:59
SELECT * FROM t2;
c1 c2
-838:59:55 -838:59:55
-838:59:59 -838:59:59
00:00:00 00:00:00
00:00:01 00:00:01
00:00:04 00:00:04
00:00:07 00:00:07
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:04:00 00:04:00
00:09:09 00:09:09
00:13:13 00:13:13
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
02:02:02 02:02:02
03:03:00 03:03:00
08:08:08 08:08:08
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
150:00:00 150:00:00
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
838:59:59 838:59:59
SELECT * FROM t3;
c1 c2
-838:59:55 -838:59:55
-838:59:59 -838:59:59
00:00:00 00:00:00
00:00:01 00:00:01
00:00:04 00:00:04
00:00:07 00:00:07
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:04:00 00:04:00
00:09:09 00:09:09
00:13:13 00:13:13
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
02:02:02 02:02:02
03:03:00 03:03:00
08:08:08 08:08:08
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
12:34:56 NULL
150:00:00 150:00:00
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
838:59:59 838:59:59
SELECT * FROM t4;
c1 c2
-838:59:55 -838:59:55
-838:59:59 -838:59:59
00:00:00 00:00:00
00:00:01 00:00:01
00:00:04 00:00:04
00:00:07 00:00:07
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:04:00 00:04:00
00:09:09 00:09:09
00:13:13 00:13:13
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
02:02:02 02:02:02
03:03:00 03:03:00
08:08:08 08:08:08
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
12:34:56 NULL
150:00:00 150:00:00
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
838:59:59 838:59:59
SELECT c1 FROM t1 WHERE c1='00:00:07';
c1
00:00:07
DELETE FROM t1 WHERE c1='00:00:07';
SELECT c1 FROM t1;
c1
-838:59:55
-838:59:59
00:00:00
00:00:01
00:00:04
00:00:08
00:00:09
00:00:10
00:00:11
00:00:12
00:00:14
00:00:50
00:00:53
00:00:59
00:03:00
00:04:00
00:09:09
00:13:13
00:51:51
00:54:54
01:01:01
02:02:02
03:03:00
08:08:08
100:04:04
11:11:11
11:11:27
125:00:00
125:05:00
12:12:12
12:34:56
150:00:00
838:00:00
838:56:00
838:58:00
838:59:51
838:59:52
838:59:55
838:59:57
838:59:58
838:59:59
SELECT c1 FROM t2 WHERE c1='-838:59:59' AND c2='-838:59:59';
c1
-838:59:59
DELETE FROM t2 WHERE c1='-838:59:59' AND c2='-838:59:59';
SELECT c1 FROM t2;
c1
-838:59:55
00:00:00
00:00:01
00:00:04
00:00:07
00:00:08
00:00:09
00:00:10
00:00:11
00:00:12
00:00:14
00:00:50
00:00:53
00:00:59
00:03:00
00:04:00
00:09:09
00:13:13
00:51:51
00:54:54
01:01:01
02:02:02
03:03:00
08:08:08
100:04:04
11:11:11
11:11:27
125:00:00
125:05:00
12:12:12
150:00:00
838:00:00
838:56:00
838:58:00
838:59:51
838:59:52
838:59:55
838:59:57
838:59:58
838:59:59
SELECT c2 FROM t3 WHERE c2=null;
c2
DELETE FROM t3 WHERE c2=null;
SELECT c2 FROM t3;
c2
-838:59:55
-838:59:59
00:00:00
00:00:01
00:00:04
00:00:07
00:00:08
00:00:09
00:00:10
00:00:11
00:00:12
00:00:14
00:00:50
00:00:53
00:00:59
00:03:00
00:04:00
00:09:09
00:13:13
00:51:51
00:54:54
01:01:01
02:02:02
03:03:00
08:08:08
100:04:04
11:11:11
11:11:27
125:00:00
125:05:00
12:12:12
150:00:00
838:00:00
838:56:00
838:58:00
838:59:51
838:59:52
838:59:55
838:59:57
838:59:58
838:59:59
NULL
SELECT c1 FROM t4 WHERE c1 < '000009';
c1
-838:59:55
-838:59:59
00:00:00
00:00:01
00:00:04
00:00:07
00:00:08
DELETE FROM t4 WHERE c1 < '000009' ORDER BY c1 LIMIT 3;
SELECT c1 FROM t4;
c1
00:00:01
00:00:04
00:00:07
00:00:08
00:00:09
00:00:10
00:00:11
00:00:12
00:00:14
00:00:50
00:00:53
00:00:59
00:03:00
00:04:00
00:09:09
00:13:13
00:51:51
00:54:54
01:01:01
02:02:02
03:03:00
08:08:08
100:04:04
11:11:11
11:11:27
125:00:00
125:05:00
12:12:12
12:34:56
150:00:00
838:00:00
838:56:00
838:58:00
838:59:51
838:59:52
838:59:55
838:59:57
838:59:58
838:59:59
DELETE FROM t1 WHERE c1='00:00:09' AND c1='01:01:01';
SELECT c2 FROM t1;
c2
-838:59:55
-838:59:59
00:00:00
00:00:01
00:00:04
00:00:08
00:00:09
00:00:10
00:00:11
00:00:12
00:00:14
00:00:50
00:00:53
00:00:59
00:03:00
00:04:00
00:09:09
00:13:13
00:51:51
00:54:54
01:01:01
02:02:02
03:03:00
08:08:08
100:04:04
11:11:11
11:11:27
125:00:00
125:05:00
12:12:12
150:00:00
838:00:00
838:56:00
838:58:00
838:59:51
838:59:52
838:59:55
838:59:57
838:59:58
838:59:59
NULL
DELETE FROM t2 WHERE c2=000400 OR c2= 000900;
SELECT c1 FROM t2;
c1
-838:59:55
00:00:00
00:00:01
00:00:04
00:00:07
00:00:08
00:00:09
00:00:10
00:00:11
00:00:12
00:00:14
00:00:50
00:00:53
00:00:59
00:03:00
00:09:09
00:13:13
00:51:51
00:54:54
01:01:01
02:02:02
03:03:00
08:08:08
100:04:04
11:11:11
11:11:27
125:00:00
125:05:00
12:12:12
150:00:00
838:00:00
838:56:00
838:58:00
838:59:51
838:59:52
838:59:55
838:59:57
838:59:58
838:59:59
DELETE FROM t2 WHERE c1 IN ('100:04:04',005454,'2:2:2',111111) ORDER BY c1 LIMIT 2;
SELECT c2 FROM t2;
c2
-838:59:55
00:00:00
00:00:01
00:00:04
00:00:07
00:00:08
00:00:09
00:00:10
00:00:11
00:00:12
00:00:14
00:00:50
00:00:53
00:00:59
00:03:00
00:09:09
00:13:13
00:51:51
01:01:01
03:03:00
08:08:08
100:04:04
11:11:11
11:11:27
125:00:00
125:05:00
12:12:12
150:00:00
838:00:00
838:56:00
838:58:00
838:59:51
838:59:52
838:59:55
838:59:57
838:59:58
838:59:59
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;
DELETE FROM t1 WHERE c1='00:09:09' AND c2='00:09:09';
SELECT * FROM t1;
c1 c2
-838:59:55 -838:59:55
-838:59:59 -838:59:59
00:00:00 00:00:00
00:00:01 00:00:01
00:00:04 00:00:04
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:04:00 00:04:00
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
02:02:02 02:02:02
03:03:00 03:03:00
08:08:08 08:08:08
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
12:34:56 NULL
150:00:00 150:00:00
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
838:59:59 838:59:59
DELETE FROM t1 WHERE c1 BETWEEN 080000 AND 100000;
SELECT * FROM t1;
c1 c2
-838:59:55 -838:59:55
-838:59:59 -838:59:59
00:00:00 00:00:00
00:00:01 00:00:01
00:00:04 00:00:04
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:04:00 00:04:00
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
02:02:02 02:02:02
03:03:00 03:03:00
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
12:34:56 NULL
150:00:00 150:00:00
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
838:59:59 838:59:59
DELETE FROM t1 WHERE c1 IN (222222,8385959,1500000);
SELECT * FROM t1;
c1 c2
-838:59:55 -838:59:55
-838:59:59 -838:59:59
00:00:00 00:00:00
00:00:01 00:00:01
00:00:04 00:00:04
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:04:00 00:04:00
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
02:02:02 02:02:02
03:03:00 03:03:00
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
12:34:56 NULL
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
DELETE t1,t2 FROM t1,t2 WHERE t1.c1=t2.c1 AND t1.c2=t2.c2;
SELECT * FROM t1;
c1 c2
-838:59:59 -838:59:59
00:04:00 00:04:00
00:54:54 00:54:54
02:02:02 02:02:02
12:34:56 NULL
SELECT * FROM t2;
c1 c2
00:00:07 00:00:07
00:09:09 00:09:09
00:13:13 00:13:13
150:00:00 150:00:00
838:59:59 838:59:59
SELECT * FROM t3;
c1 c2
-838:59:55 -838:59:55
-838:59:59 -838:59:59
00:00:00 00:00:00
00:00:01 00:00:01
00:00:04 00:00:04
00:00:07 00:00:07
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:04:00 00:04:00
00:09:09 00:09:09
00:13:13 00:13:13
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
03:03:00 03:03:00
08:08:08 08:08:08
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
12:34:56 NULL
150:00:00 150:00:00
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
838:59:59 838:59:59
SELECT * FROM t4;
c1 c2
00:00:01 00:00:01
00:00:04 00:00:04
00:00:07 00:00:07
00:00:08 00:00:08
00:00:09 00:00:09
00:00:10 00:00:10
00:00:11 00:00:11
00:00:12 00:00:12
00:00:14 00:00:14
00:00:50 00:00:50
00:00:53 00:00:53
00:00:59 00:00:59
00:03:00 00:03:00
00:09:09 00:09:09
00:13:13 00:13:13
00:51:51 00:51:51
00:54:54 00:54:54
01:01:01 01:01:01
02:02:02 02:02:02
03:03:00 03:03:00
08:08:08 08:08:08
100:04:04 100:04:04
11:11:11 11:11:11
11:11:27 11:11:27
125:00:00 125:00:00
125:05:00 125:05:00
12:12:12 12:12:12
12:34:56 NULL
150:00:00 150:00:00
838:00:00 838:00:00
838:56:00 838:56:00
838:58:00 838:58:00
838:59:51 838:59:51
838:59:52 838:59:52
838:59:55 838:59:55
838:59:57 838:59:57
838:59:58 838:59:58
838:59:59 838:59:59
DROP TABLE IF EXISTS t1,t2,t3,t4;

Messung V0.5 in Prozent
C=92 H=100 G=95

¤ Dauer der Verarbeitung: 0.17 Sekunden  (vorverarbeitet am  2026-10-08) ¤

*© Formatika GbR, Deutschland




Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.

Bemerkung:

Die farbliche Syntaxdarstellung und die Messung sind noch experimentell.





                                                                                                                                                                                                                                                                                                                                                                                                     

Neuigkeiten

     Aktuelles
     Motto des Tages

letze Version des Elbe Quellennavigators

Jenseits des Üblichen ....

Besucher

Besucher
Statistik
#Sources=1126864
#Domains=1897691