Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_multicolumn_calendar_pk_constraint_duplicate_update.result

raw
1 DROP TABLE IF EXISTS t1;
2 SET sql_mode='NO_ENGINE_SUBSTITUTION';
3 SET TIME_ZONE="+03:00";
4 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 DATE NOT NULL, PRIMARY KEY(c1,c2,c3));
5 SET TIMESTAMP=1171346973;
6 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
7 Warnings:
8 Note 1265 Data truncated for column 'c1' at row 1
9 Note 1265 Data truncated for column 'c2' at row 1
10 Note 1265 Data truncated for column 'c3' at row 1
11 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
12 Warnings:
13 Note 1265 Data truncated for column 'c1' at row 1
14 Note 1265 Data truncated for column 'c2' at row 1
15 Note 1265 Data truncated for column 'c3' at row 1
16 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
17 Warnings:
18 Note 1265 Data truncated for column 'c1' at row 1
19 Note 1265 Data truncated for column 'c2' at row 1
20 Note 1265 Data truncated for column 'c3' at row 1
21 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
22 Warnings:
23 Note 1265 Data truncated for column 'c1' at row 1
24 Note 1265 Data truncated for column 'c2' at row 1
25 Note 1265 Data truncated for column 'c3' at row 1
26 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');
27 Warnings:
28 Note 1265 Data truncated for column 'c1' at row 1
29 Note 1265 Data truncated for column 'c2' at row 1
30 Note 1265 Data truncated for column 'c3' at row 1
31 Note 1265 Data truncated for column 'c1' at row 1
32 Note 1265 Data truncated for column 'c2' at row 1
33 Note 1265 Data truncated for column 'c3' at row 1
34 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');
35 Warnings:
36 Note 1265 Data truncated for column 'c1' at row 1
37 Note 1265 Data truncated for column 'c2' at row 1
38 Note 1265 Data truncated for column 'c3' at row 1
39 Note 1265 Data truncated for column 'c1' at row 1
40 Note 1265 Data truncated for column 'c2' at row 1
41 SELECT * FROM t1;
42 c1 c2 c3
43 2007-02-13 2007-02-14 2007-02-13
44 2007-02-14 2007-02-13 2007-02-13
45 2007-02-15 2007-02-15 2007-02-14
46 2007-02-15 2007-02-15 2007-02-15
47 DROP TABLE t1;
48 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
49 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
50 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
51 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
52 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
53 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
54 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
55 SELECT * FROM t1;
56 c1 c2 c3
57 1999 2000 1999
58 2000 1999 1999
59 2011 2011 2000
60 2011 2011 2011
61 DROP TABLE t1;
62 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL, PRIMARY KEY(c1,c2,c3));
63 SET TIMESTAMP=1171346973;
64 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
65 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
66 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
67 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
68 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');
69 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');
70 SELECT * FROM t1;
71 c1 c2 c3
72 09:09:33 10:10:34 09:09:33
73 10:10:34 09:09:33 09:09:33
74 11:10:34 11:10:34 10:10:34
75 11:10:34 11:10:34 11:10:34
76 DROP TABLE t1;
77 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
78 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
79 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
80 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
81 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
82 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
83 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
84 SELECT * FROM t1;
85 c1 c2 c3
86 1999 2000 1999
87 2000 1999 1999
88 2011 2011 2000
89 2011 2011 2011
90 DROP TABLE t1;
91 CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NOT NULL, c3 DATETIME NOT NULL, PRIMARY KEY(c1,c2,c3));
92 SET TIMESTAMP=1171346973;
93 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
94 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
95 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
96 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
97 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');
98 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');
99 SELECT * FROM t1;
100 c1 c2 c3
101 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
102 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
103 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-14 10:10:34
104 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-15 11:10:34
105 DROP TABLE t1;
106 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
107 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
108 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
109 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
110 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
111 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
112 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
113 SELECT * FROM t1;
114 c1 c2 c3
115 1999 2000 1999
116 2000 1999 1999
117 2011 2011 2000
118 2011 2011 2011
119 DROP TABLE t1;
120 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL, PRIMARY KEY(c1,c2,c3));
121 SET TIMESTAMP=1171346973;
122 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
123 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
124 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
125 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
126 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');
127 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');
128 SELECT * FROM t1;
129 c1 c2 c3
130 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
131 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
132 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-14 10:10:34
133 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-15 11:10:34
134 DROP TABLE t1;
135 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
136 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
137 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
138 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
139 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
140 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999) ON DUPLICATE KEY UPDATE c1=2011,c2=2011,c3=2011;
141 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000) ON DUPLICATE KEY UPDATE c1=2011,c2=2011;
142 SELECT * FROM t1;
143 c1 c2 c3
144 1999 2000 1999
145 2000 1999 1999
146 2011 2011 2000
147 2011 2011 2011
148 DROP TABLE t1;
149 SET TIME_ZONE= @@global.time_zone;
150 SET sql_mode=default;