Debian Codegraph @

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