Debian Codegraph @

mysql-test/suite/engines/funcs/t/up_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);
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 --sorted_result
15 SELECT * FROM t1 ORDER BY c1;
16 UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
17 --sorted_result
18 SELECT * FROM t1 ORDER BY c1;
19 DROP TABLE t1;
20 CREATE TABLE t1(c1 TIME NOT NULL);
21 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
22 INSERT INTO t1 (c1) VALUES(NOW());
23 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
24 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
25 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
26 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
27 --sorted_result
28 SELECT * FROM t1 ORDER BY c1;
29 UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
30 --sorted_result
31 SELECT * FROM t1 ORDER BY c1;
32 DROP TABLE t1;
33 CREATE TABLE t1(c1 DATETIME NOT NULL);
34 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
35 INSERT INTO t1 (c1) VALUES(NOW());
36 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
37 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
38 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
39 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
40 --sorted_result
41 SELECT * FROM t1 ORDER BY c1;
42 UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
43 --sorted_result
44 SELECT * FROM t1 ORDER BY c1;
45 DROP TABLE t1;
46 CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
47 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
48 INSERT INTO t1 (c1) VALUES(NOW());
49 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
50 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01'));
51 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01'));
52 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01'));
53 --sorted_result
54 SELECT * FROM t1 ORDER BY c1;
55 UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01');
56 --sorted_result
57 SELECT * FROM t1 ORDER BY c1;
58 DROP TABLE t1;
59 # Restore timezone to default
60 SET TIME_ZONE= @@global.time_zone;
61 SET sql_mode=default;