Debian Codegraph @

mysql-test/suite/engines/funcs/t/de_calendar_range.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1,t2,t3;
3 --enable_warnings
4 # Set Correct timezone to match result
5 SET TIME_ZONE="+03:00";
6 CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY);
7 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
8 INSERT INTO t1 (c1) VALUES(NOW());
9 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
10 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
11 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
12 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
13 SELECT * FROM t1 ORDER BY c1;
14 DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
15 SELECT * FROM t1 ORDER BY c1;
16 DROP TABLE t1;
17 CREATE TABLE t1(c1 TIME NOT NULL PRIMARY KEY);
18 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
19 INSERT INTO t1 (c1) VALUES(NOW());
20 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
21 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
22 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
23 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
24 SELECT * FROM t1 ORDER BY c1;
25 DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
26 SELECT * FROM t1 ORDER BY c1;
27 DROP TABLE t1;
28 CREATE TABLE t1(c1 DATETIME NOT NULL PRIMARY KEY);
29 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
30 INSERT INTO t1 (c1) VALUES(NOW());
31 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
32 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
33 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
34 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
35 SELECT * FROM t1 ORDER BY c1;
36 DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
37 SELECT * FROM t1 ORDER BY c1;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 TIMESTAMP NOT NULL PRIMARY KEY);
40 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
41 INSERT INTO t1 (c1) VALUES(NOW());
42 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
43 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
44 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
45 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
46 SELECT * FROM t1 ORDER BY c1;
47 DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
48 SELECT * FROM t1 ORDER BY c1;
49 DROP TABLE t1;
50 # Restore timezone to default
51 SET TIME_ZONE= @@global.time_zone;