Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_multicolumn_calendar_pk_constraint_ignore.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());
27 ERROR 23000: Duplicate entry '2007-02-13-2007-02-13-2007-02-13' for key 't1.PRIMARY'
28 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
29 ERROR 23000: Duplicate entry '2007-02-13-2007-02-13-2007-02-14' for key 't1.PRIMARY'
30 SELECT * FROM t1;
31 c1 c2 c3
32 2007-02-13 2007-02-13 2007-02-13
33 2007-02-13 2007-02-13 2007-02-14
34 2007-02-13 2007-02-14 2007-02-13
35 2007-02-14 2007-02-13 2007-02-13
36 DROP TABLE t1;
37 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
38 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
39 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
40 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
41 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
42 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
43 ERROR 23000: Duplicate entry '1999-1999-1999' for key 't1.PRIMARY'
44 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
45 ERROR 23000: Duplicate entry '1999-1999-2000' for key 't1.PRIMARY'
46 SELECT * FROM t1;
47 c1 c2 c3
48 1999 1999 1999
49 1999 1999 2000
50 1999 2000 1999
51 2000 1999 1999
52 DROP TABLE t1;
53 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL, PRIMARY KEY(c1,c2,c3));
54 SET TIMESTAMP=1171346973;
55 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
56 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
57 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
58 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
59 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
60 ERROR 23000: Duplicate entry '09:09:33-09:09:33-09:09:33' for key 't1.PRIMARY'
61 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
62 ERROR 23000: Duplicate entry '09:09:33-09:09:33-10:10:34' for key 't1.PRIMARY'
63 SELECT * FROM t1;
64 c1 c2 c3
65 09:09:33 09:09:33 09:09:33
66 09:09:33 09:09:33 10:10:34
67 09:09:33 10:10:34 09:09:33
68 10:10:34 09:09:33 09:09:33
69 DROP TABLE t1;
70 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
71 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
72 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
73 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
74 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
75 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
76 ERROR 23000: Duplicate entry '1999-1999-1999' for key 't1.PRIMARY'
77 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
78 ERROR 23000: Duplicate entry '1999-1999-2000' for key 't1.PRIMARY'
79 SELECT * FROM t1;
80 c1 c2 c3
81 1999 1999 1999
82 1999 1999 2000
83 1999 2000 1999
84 2000 1999 1999
85 DROP TABLE t1;
86 CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NOT NULL, c3 DATETIME NOT NULL, PRIMARY KEY(c1,c2,c3));
87 SET TIMESTAMP=1171346973;
88 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
89 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
90 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
91 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
92 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
93 ERROR 23000: Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-13 09:09:33' for key 't1.PRIMARY'
94 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
95 ERROR 23000: Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-14 10:10:34' for key 't1.PRIMARY'
96 SELECT * FROM t1;
97 c1 c2 c3
98 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-13 09:09:33
99 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-14 10:10:34
100 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
101 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
102 DROP TABLE t1;
103 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
104 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
105 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
106 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
107 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
108 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
109 ERROR 23000: Duplicate entry '1999-1999-1999' for key 't1.PRIMARY'
110 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
111 ERROR 23000: Duplicate entry '1999-1999-2000' for key 't1.PRIMARY'
112 SELECT * FROM t1;
113 c1 c2 c3
114 1999 1999 1999
115 1999 1999 2000
116 1999 2000 1999
117 2000 1999 1999
118 DROP TABLE t1;
119 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL, PRIMARY KEY(c1,c2,c3));
120 SET TIMESTAMP=1171346973;
121 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
122 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
123 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'1 01:01:01'),NOW());
124 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),NOW(),NOW());
125 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
126 ERROR 23000: Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-13 09:09:33' for key 't1.PRIMARY'
127 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),ADDTIME(NOW(),'1 01:01:01'));
128 ERROR 23000: Duplicate entry '2007-02-13 09:09:33-2007-02-13 09:09:33-2007-02-14 10:10:34' for key 't1.PRIMARY'
129 SELECT * FROM t1;
130 c1 c2 c3
131 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-13 09:09:33
132 2007-02-13 09:09:33 2007-02-13 09:09:33 2007-02-14 10:10:34
133 2007-02-13 09:09:33 2007-02-14 10:10:34 2007-02-13 09:09:33
134 2007-02-14 10:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
135 DROP TABLE t1;
136 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL, PRIMARY KEY(c1,c2,c3));
137 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
138 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
139 INSERT INTO t1 (c1,c2,c3) VALUES(1999,2000,1999);
140 INSERT INTO t1 (c1,c2,c3) VALUES(2000,1999,1999);
141 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,1999);
142 ERROR 23000: Duplicate entry '1999-1999-1999' for key 't1.PRIMARY'
143 INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
144 ERROR 23000: Duplicate entry '1999-1999-2000' for key 't1.PRIMARY'
145 SELECT * FROM t1;
146 c1 c2 c3
147 1999 1999 1999
148 1999 1999 2000
149 1999 2000 1999
150 2000 1999 1999
151 DROP TABLE t1;
152 SET TIME_ZONE= @@global.time_zone;
153 SET sql_mode=default;