Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_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 UNIQUE);
4 SET TIMESTAMP=1171346973;
5 INSERT INTO t1 (c1) VALUES(NOW());
6 Warnings:
7 Note 1265 Data truncated for column 'c1' at row 1
8 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
9 Warnings:
10 Note 1265 Data truncated for column 'c1' at row 1
11 INSERT IGNORE INTO t1 (c1) VALUES(NOW());
12 Warnings:
13 Note 1265 Data truncated for column 'c1' at row 1
14 Warning 1062 Duplicate entry '2007-02-13' for key 'c1'
15 SELECT * FROM t1;
16 c1
17 2007-02-13
18 2007-02-14
19 DROP TABLE t1;
20 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
21 INSERT INTO t1 (c1) VALUES(1999);
22 INSERT INTO t1 (c1) VALUES(2000);
23 INSERT IGNORE INTO t1 (c1) VALUES(1999);
24 Warnings:
25 Warning 1062 Duplicate entry '1999' for key 'c1'
26 SELECT * FROM t1;
27 c1
28 1999
29 2000
30 DROP TABLE t1;
31 CREATE TABLE t1(c1 TIME NULL UNIQUE);
32 SET TIMESTAMP=1171346973;
33 INSERT INTO t1 (c1) VALUES(NOW());
34 Warnings:
35 Note 1265 Data truncated for column 'c1' at row 1
36 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
37 Warnings:
38 Note 1265 Data truncated for column 'c1' at row 1
39 INSERT IGNORE INTO t1 (c1) VALUES(NOW());
40 Warnings:
41 Note 1265 Data truncated for column 'c1' at row 1
42 Warning 1062 Duplicate entry '09:09:33' for key 'c1'
43 SELECT * FROM t1;
44 c1
45 09:09:33
46 10:10:34
47 DROP TABLE t1;
48 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
49 INSERT INTO t1 (c1) VALUES(1999);
50 INSERT INTO t1 (c1) VALUES(2000);
51 INSERT IGNORE INTO t1 (c1) VALUES(1999);
52 Warnings:
53 Warning 1062 Duplicate entry '1999' for key 'c1'
54 SELECT * FROM t1;
55 c1
56 1999
57 2000
58 DROP TABLE t1;
59 CREATE TABLE t1(c1 DATETIME NULL UNIQUE);
60 SET TIMESTAMP=1171346973;
61 INSERT INTO t1 (c1) VALUES(NOW());
62 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
63 INSERT IGNORE INTO t1 (c1) VALUES(NOW());
64 Warnings:
65 Warning 1062 Duplicate entry '2007-02-13 09:09:33' for key 'c1'
66 SELECT * FROM t1;
67 c1
68 2007-02-13 09:09:33
69 2007-02-14 10:10:34
70 DROP TABLE t1;
71 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
72 INSERT INTO t1 (c1) VALUES(1999);
73 INSERT INTO t1 (c1) VALUES(2000);
74 INSERT IGNORE INTO t1 (c1) VALUES(1999);
75 Warnings:
76 Warning 1062 Duplicate entry '1999' for key 'c1'
77 SELECT * FROM t1;
78 c1
79 1999
80 2000
81 DROP TABLE t1;
82 CREATE TABLE t1(c1 TIMESTAMP NULL UNIQUE);
83 SET TIMESTAMP=1171346973;
84 INSERT INTO t1 (c1) VALUES(NOW());
85 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
86 INSERT IGNORE INTO t1 (c1) VALUES(NOW());
87 Warnings:
88 Warning 1062 Duplicate entry '2007-02-13 09:09:33' for key 'c1'
89 SELECT * FROM t1;
90 c1
91 2007-02-13 09:09:33
92 2007-02-14 10:10:34
93 DROP TABLE t1;
94 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
95 INSERT INTO t1 (c1) VALUES(1999);
96 INSERT INTO t1 (c1) VALUES(2000);
97 INSERT IGNORE INTO t1 (c1) VALUES(1999);
98 Warnings:
99 Warning 1062 Duplicate entry '1999' for key 'c1'
100 SELECT * FROM t1;
101 c1
102 1999
103 2000
104 DROP TABLE t1;
105 SET TIME_ZONE= @@global.time_zone;