Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_calendar_pk_constraint_ignore.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 SET sql_mode='NO_ENGINE_SUBSTITUTION';
5 # Set Correct timezone to match result
6 SET TIME_ZONE="+03:00";
7 CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY);
8 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
9 INSERT INTO t1 (c1) VALUES(NOW());
10 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
11 --error ER_DUP_ENTRY
12 INSERT INTO t1 (c1) VALUES(NOW());
13 SELECT * FROM t1;
14 DROP TABLE t1;
15 CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
16 INSERT INTO t1 (c1) VALUES(1999);
17 INSERT INTO t1 (c1) VALUES(2000);
18 --error ER_DUP_ENTRY
19 INSERT INTO t1 (c1) VALUES(1999);
20 SELECT * FROM t1;
21 DROP TABLE t1;
22 CREATE TABLE t1(c1 TIME NOT NULL PRIMARY KEY);
23 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
24 INSERT INTO t1 (c1) VALUES(NOW());
25 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
26 --error ER_DUP_ENTRY
27 INSERT INTO t1 (c1) VALUES(NOW());
28 SELECT * FROM t1;
29 DROP TABLE t1;
30 CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
31 INSERT INTO t1 (c1) VALUES(1999);
32 INSERT INTO t1 (c1) VALUES(2000);
33 --error ER_DUP_ENTRY
34 INSERT INTO t1 (c1) VALUES(1999);
35 SELECT * FROM t1;
36 DROP TABLE t1;
37 CREATE TABLE t1(c1 DATETIME NOT NULL PRIMARY KEY);
38 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
39 INSERT INTO t1 (c1) VALUES(NOW());
40 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
41 --error ER_DUP_ENTRY
42 INSERT INTO t1 (c1) VALUES(NOW());
43 SELECT * FROM t1;
44 DROP TABLE t1;
45 CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
46 INSERT INTO t1 (c1) VALUES(1999);
47 INSERT INTO t1 (c1) VALUES(2000);
48 --error ER_DUP_ENTRY
49 INSERT INTO t1 (c1) VALUES(1999);
50 SELECT * FROM t1;
51 DROP TABLE t1;
52 CREATE TABLE t1(c1 TIMESTAMP NOT NULL PRIMARY KEY);
53 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
54 INSERT INTO t1 (c1) VALUES(NOW());
55 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
56 --error ER_DUP_ENTRY
57 INSERT INTO t1 (c1) VALUES(NOW());
58 SELECT * FROM t1;
59 DROP TABLE t1;
60 CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY);
61 INSERT INTO t1 (c1) VALUES(1999);
62 INSERT INTO t1 (c1) VALUES(2000);
63 --error ER_DUP_ENTRY
64 INSERT INTO t1 (c1) VALUES(1999);
65 SELECT * FROM t1;
66 DROP TABLE t1;
67 # Restore timezone to default
68 SET TIME_ZONE= @@global.time_zone;
69 SET sql_mode=default;