Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_multicolumn_calendar_unique_constraint_ignore.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 1292 Incorrect date value: '2007-02-13 09:09:33' for column 'c1' at row 1
8 Note 1292 Incorrect date value: '2007-02-13 09:09:33' for column 'c2' at row 1
9 Note 1292 Incorrect date value: '2007-02-13 09:09:33' 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 1292 Incorrect date value: '2007-02-13 09:09:33' for column 'c1' at row 1
13 Note 1292 Incorrect date value: '2007-02-13 09:09:33' for column 'c2' at row 1
14 Note 1292 Incorrect date value: '2007-02-14 10:10:34' 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 1292 Incorrect date value: '2007-02-13 09:09:33' for column 'c1' at row 1
18 Note 1292 Incorrect date value: '2007-02-14 10:10:34' for column 'c2' at row 1
19 Note 1292 Incorrect date value: '2007-02-13 09:09:33' 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 1292 Incorrect date value: '2007-02-14 10:10:34' for column 'c1' at row 1
23 Note 1292 Incorrect date value: '2007-02-13 09:09:33' for column 'c2' at row 1
24 Note 1292 Incorrect date value: '2007-02-13 09:09:33' for column 'c3' at row 1
25 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),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 Warning 1062 Duplicate entry '2007-02-13-2007-02-13-2007-02-13' for key 't1.c1'
31 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
32 Warnings:
33 Note 1265 Data truncated for column 'c1' at row 1
34 Note 1265 Data truncated for column 'c2' at row 1
35 Note 1265 Data truncated for column 'c3' at row 1
36 Warning 1062 Duplicate entry '2007-02-13-2007-02-13-2007-02-14' for key 't1.c1'
37 SELECT * FROM t1;
38 c1 c2 c3
39 2007-02-13 2007-02-13 2007-02-13
40 2007-02-13 2007-02-13 2007-02-14
41 2007-02-13 2007-02-14 2007-02-13
42 2007-02-14 2007-02-13 2007-02-13
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 YEAR NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(c1,c2,c3));
45 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
46 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
47 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
48 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
49 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
50 Warnings:
51 Warning 1062 Duplicate entry '1999-1999-1999' for key 't1.c1'
52 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
53 Warnings:
54 Warning 1062 Duplicate entry '1999-1999-2000' for key 't1.c1'
55 SELECT * FROM t1;
56 c1 c2 c3
57 1999 1999 1999
58 1999 1999 2000
59 1999 2000 1999
60 2000 1999 1999
61 DROP TABLE t1;
62 CREATE TABLE t1(c1 TIME NULL, c2 TIME NULL, c3 TIME NULL, UNIQUE(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 IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
69 Warnings:
70 Warning 1062 Duplicate entry '09:09:33-09:09:33-09:09:33' for key 't1.c1'
71 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
72 Warnings:
73 Warning 1062 Duplicate entry '09:09:33-09:09:33-10:10:34' for key 't1.c1'
74 SELECT * FROM t1;
75 c1 c2 c3
76 09:09:33 09:09:33 09:09:33
77 09:09:33 09:09:33 10:10:34
78 09:09:33 10:10:34 09:09:33
79 10:10:34 09:09:33 09:09:33
80 DROP TABLE t1;
81 CREATE TABLE t1(c1 YEAR NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(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 IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
87 Warnings:
88 Warning 1062 Duplicate entry '1999-1999-1999' for key 't1.c1'
89 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
90 Warnings:
91 Warning 1062 Duplicate entry '1999-1999-2000' for key 't1.c1'
92 SELECT * FROM t1;
93 c1 c2 c3
94 1999 1999 1999
95 1999 1999 2000
96 1999 2000 1999
97 2000 1999 1999
98 DROP TABLE t1;
99 CREATE TABLE t1(c1 DATETIME NULL, c2 DATETIME NULL, c3 DATETIME NULL, UNIQUE(c1,c2,c3));
100 SET TIMESTAMP=1171346973;
101 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
102 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
103 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
104 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
105 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
106 Warnings:
107 Warning 1062 Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-13 09:09:33' for key 't1.c1'
108 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
109 Warnings:
110 Warning 1062 Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-14 10:10:34' for key 't1.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 IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
124 Warnings:
125 Warning 1062 Duplicate entry '1999-1999-1999' for key 't1.c1'
126 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
127 Warnings:
128 Warning 1062 Duplicate entry '1999-1999-2000' for key 't1.c1'
129 SELECT * FROM t1;
130 c1 c2 c3
131 1999 1999 1999
132 1999 1999 2000
133 1999 2000 1999
134 2000 1999 1999
135 DROP TABLE t1;
136 CREATE TABLE t1(c1 TIMESTAMP NULL, c2 TIMESTAMP NULL, c3 TIMESTAMP NULL, UNIQUE(c1,c2,c3));
137 SET TIMESTAMP=1171346973;
138 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
139 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
140 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
141 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
142 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
143 Warnings:
144 Warning 1062 Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-13 09:09:33' for key 't1.c1'
145 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
146 Warnings:
147 Warning 1062 Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-14 10:10:34' for key 't1.c1'
148 SELECT * FROM t1;
149 c1 c2 c3
150 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-13 09:09:33
151 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-14 10:10:34
152 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
153 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
154 DROP TABLE t1;
155 CREATE TABLE t1(c1 YEAR NULL, c2 YEAR NULL, c3 YEAR NULL, UNIQUE(c1,c2,c3));
156 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
157 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
158 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
159 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
160 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
161 Warnings:
162 Warning 1062 Duplicate entry '1999-1999-1999' for key 't1.c1'
163 INSERT IGNORE INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
164 Warnings:
165 Warning 1062 Duplicate entry '1999-1999-2000' for key 't1.c1'
166 SELECT * FROM t1;
167 c1 c2 c3
168 1999 1999 1999
169 1999 1999 2000
170 1999 2000 1999
171 2000 1999 1999
172 DROP TABLE t1;
173 SET TIME_ZONE= @@global.time_zone;