Debian Codegraph @

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

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