Debian Codegraph @

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