Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 # Set Correct timezone to match result
5 SET TIME_ZONE="+03:00";
6 CREATE TABLE t1(c1 DATE NULL UNIQUE);
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(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
11 --sorted_result
12 SELECT * FROM t1;
13 DROP TABLE t1;
14 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
15 INSERT INTO t1 (c1) VALUES(1999);
16 INSERT INTO t1 (c1) VALUES(2000);
17 INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
18 --sorted_result
19 SELECT * FROM t1;
20 DROP TABLE t1;
21 CREATE TABLE t1(c1 TIME NULL UNIQUE);
22 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
23 INSERT INTO t1 (c1) VALUES(NOW());
24 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
25 INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
26 --sorted_result
27 SELECT * FROM t1;
28 DROP TABLE t1;
29 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
30 INSERT INTO t1 (c1) VALUES(1999);
31 INSERT INTO t1 (c1) VALUES(2000);
32 INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
33 --sorted_result
34 SELECT * FROM t1;
35 DROP TABLE t1;
36 CREATE TABLE t1(c1 DATETIME NULL UNIQUE);
37 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
38 INSERT INTO t1 (c1) VALUES(NOW());
39 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
40 INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
41 --sorted_result
42 SELECT * FROM t1;
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
45 INSERT INTO t1 (c1) VALUES(1999);
46 INSERT INTO t1 (c1) VALUES(2000);
47 INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
48 --sorted_result
49 SELECT * FROM t1;
50 DROP TABLE t1;
51 CREATE TABLE t1(c1 TIMESTAMP NULL UNIQUE);
52 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
53 INSERT INTO t1 (c1) VALUES(NOW());
54 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
55 INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01');
56 --sorted_result
57 SELECT * FROM t1;
58 DROP TABLE t1;
59 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
60 INSERT INTO t1 (c1) VALUES(1999);
61 INSERT INTO t1 (c1) VALUES(2000);
62 INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011;
63 --sorted_result
64 SELECT * FROM t1;
65 DROP TABLE t1;
66 # Restore timezone to default
67 SET TIME_ZONE= @@global.time_zone;