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