Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_multicolumn_calendar_pk_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 NOT NULL, c2 DATE NOT NULL, c3 DATE NOT NULL, PRIMARY KEY(c1,c2,c3));
8 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
9 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
10 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
11 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
12 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
13 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
14 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
15 --sorted_result
16 SELECT * FROM t1;
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
19 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
20 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
21 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
22 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
23 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
24 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
25 --sorted_result
26 SELECT * FROM t1;
27 DROP TABLE t1;
28 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL, PRIMARY KEY(c1,c2,c3));
29 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
30 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
31 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
32 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
33 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
34 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
35 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
36 --sorted_result
37 SELECT * FROM t1;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
40 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
41 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
42 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
43 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
44 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
45 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
46 --sorted_result
47 SELECT * FROM t1;
48 DROP TABLE t1;
49 CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NOT NULL, c3 DATETIME NOT NULL, PRIMARY KEY(c1,c2,c3));
50 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
51 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
52 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
53 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
54 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
55 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
56 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
57 --sorted_result
58 SELECT * FROM t1;
59 DROP TABLE t1;
60 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
61 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
62 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
63 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
64 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
65 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
66 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
67 --sorted_result
68 SELECT * FROM t1;
69 DROP TABLE t1;
70 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL, PRIMARY KEY(c1,c2,c3));
71 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
72 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
73 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
74 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
75 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
76 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01'),c3=ADDTIME(NOW(),'2 02:01:01');
77 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01')) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'),c2=ADDTIME(NOW(),'2 02:01:01');
78 --sorted_result
79 SELECT * FROM t1;
80 DROP TABLE t1;
81 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
82 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
83 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
84 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
85 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
86 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
87 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
88 --sorted_result
89 SELECT * FROM t1;
90 DROP TABLE t1;
91 # Restore timezone to default
92 SET TIME_ZONE= @@global.time_zone;
93 SET sql_mode=default;