Debian Codegraph @

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

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