Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 # Set Correct timezone to match result
5 SET TIME_ZONE="+03:00";
6 CREATE TABLE t1(c1 DATE NULL UNIQUE);
7 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
8 INSERT INTO t1 (c1) VALUES(NOW());
9 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
10 INSERT IGNORE INTO t1 (c1) VALUES(NOW());
11 SELECT * FROM t1;
12 DROP TABLE t1;
13 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
14 INSERT INTO t1 (c1) VALUES(1999);
15 INSERT INTO t1 (c1) VALUES(2000);
16 INSERT IGNORE INTO t1 (c1) VALUES(1999);
17 SELECT * FROM t1;
18 DROP TABLE t1;
19 CREATE TABLE t1(c1 TIME NULL UNIQUE);
20 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
21 INSERT INTO t1 (c1) VALUES(NOW());
22 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
23 INSERT IGNORE INTO t1 (c1) VALUES(NOW());
24 SELECT * FROM t1;
25 DROP TABLE t1;
26 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
27 INSERT INTO t1 (c1) VALUES(1999);
28 INSERT INTO t1 (c1) VALUES(2000);
29 INSERT IGNORE INTO t1 (c1) VALUES(1999);
30 SELECT * FROM t1;
31 DROP TABLE t1;
32 CREATE TABLE t1(c1 DATETIME NULL UNIQUE);
33 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
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 SELECT * FROM t1;
38 DROP TABLE t1;
39 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
40 INSERT INTO t1 (c1) VALUES(1999);
41 INSERT INTO t1 (c1) VALUES(2000);
42 INSERT IGNORE INTO t1 (c1) VALUES(1999);
43 SELECT * FROM t1;
44 DROP TABLE t1;
45 CREATE TABLE t1(c1 TIMESTAMP NULL UNIQUE);
46 SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
47 INSERT INTO t1 (c1) VALUES(NOW());
48 INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01'));
49 INSERT IGNORE INTO t1 (c1) VALUES(NOW());
50 SELECT * FROM t1;
51 DROP TABLE t1;
52 CREATE TABLE t1(c1 YEAR NULL UNIQUE);
53 INSERT INTO t1 (c1) VALUES(1999);
54 INSERT INTO t1 (c1) VALUES(2000);
55 INSERT IGNORE INTO t1 (c1) VALUES(1999);
56 SELECT * FROM t1;
57 DROP TABLE t1;
58 #restore timezone to default
59 SET TIME_ZONE= @@global.time_zone;