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