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