[tomato.git] / release / src / router / mysql / mysql-test / suite / engines / funcs / r / in_calendar_2_unique_constraints_duplicate_update.result
| blob | 9c56e23574d2f5fcfbd17a8a5f19b41da8e30e90 |
1 DROP TABLE IF EXISTS t1;
2 SET TIME_ZONE="+03:00";
3 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NULL, c3 DATE NULL, PRIMARY KEY(c1), UNIQUE(c2));
4 SET TIMESTAMP=1171346973;
5 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'4 04:01:01'),NOW());
6 Warnings:
7 Note 1265 Data truncated for column 'c1' at row 1
8 Note 1265 Data truncated for column 'c2' at row 1
9 Note 1265 Data truncated for column 'c3' at row 1
10 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),ADDTIME(NOW(),'3 03:01:01'),NOW());
11 Warnings:
12 Note 1265 Data truncated for column 'c1' at row 1
13 Note 1265 Data truncated for column 'c2' at row 1
14 Note 1265 Data truncated for column 'c3' at row 1
15 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW());
16 Warnings:
17 Note 1265 Data truncated for column 'c1' at row 1
18 Note 1265 Data truncated for column 'c2' at row 1
19 Note 1265 Data truncated for column 'c3' at row 1
20 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'3 03:01:01'),ADDTIME(NOW(),'1 01:01:01'),NOW());
21 Warnings:
22 Note 1265 Data truncated for column 'c1' at row 1
23 Note 1265 Data truncated for column 'c2' at row 1
24 Note 1265 Data truncated for column 'c3' at row 1
25 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'4 04:01:01'),NOW(),NOW());
26 Warnings:
27 Note 1265 Data truncated for column 'c1' at row 1
28 Note 1265 Data truncated for column 'c2' at row 1
29 Note 1265 Data truncated for column 'c3' at row 1
30 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
31 Warnings:
32 Note 1265 Data truncated for column 'c1' at row 1
33 Note 1265 Data truncated for column 'c2' at row 1
34 Note 1265 Data truncated for column 'c3' at row 1
35 Note 1265 Data truncated for column 'c3' at row 1
36 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
37 Warnings:
38 Note 1265 Data truncated for column 'c1' at row 1
39 Note 1265 Data truncated for column 'c2' at row 1
40 Note 1265 Data truncated for column 'c3' at row 1
41 Note 1265 Data truncated for column 'c3' at row 1
42 SELECT * FROM t1;
43 c1 c2 c3
44 2007-02-13 2007-02-17 2007-02-19
45 2007-02-14 2007-02-16 2007-02-13
46 2007-02-15 2007-02-15 2007-02-19
47 2007-02-16 2007-02-14 2007-02-13
48 2007-02-17 2007-02-13 2007-02-13
49 DROP TABLE t1;
50 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NULL, c3 YEAR NULL, PRIMARY KEY(c1), UNIQUE(c2));
51 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2004,2000);
52 INSERT INTO t1 (c1,c2,c3) VALUES(2001,2003,2000);
53 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000);
54 INSERT INTO t1 (c1,c2,c3) VALUES(2003,2001,2000);
55 INSERT INTO t1 (c1,c2,c3) VALUES(2004,2000,2000);
56 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000) ON DUPLICATE KEY UPDATE c3=2011;
57 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2000,2000) ON DUPLICATE KEY UPDATE c3=2011;
58 SELECT * FROM t1;
59 c1 c2 c3
60 2000 2004 2011
61 2001 2003 2000
62 2002 2002 2011
63 2003 2001 2000
64 2004 2000 2000
65 DROP TABLE t1;
66 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, c3 TIME NULL, PRIMARY KEY(c1), UNIQUE(c2));
67 SET TIMESTAMP=1171346973;
68 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'4 04:01:01'),NOW());
69 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),ADDTIME(NOW(),'3 03:01:01'),NOW());
70 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW());
71 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'3 03:01:01'),ADDTIME(NOW(),'1 01:01:01'),NOW());
72 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'4 04:01:01'),NOW(),NOW());
73 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
74 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
75 SELECT * FROM t1;
76 c1 c2 c3
77 09:09:33 13:10:34 15:10:34
78 10:10:34 12:10:34 09:09:33
79 11:10:34 11:10:34 15:10:34
80 12:10:34 10:10:34 09:09:33
81 13:10:34 09:09:33 09:09:33
82 DROP TABLE t1;
83 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NULL, c3 YEAR NULL, PRIMARY KEY(c1), UNIQUE(c2));
84 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2004,2000);
85 INSERT INTO t1 (c1,c2,c3) VALUES(2001,2003,2000);
86 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000);
87 INSERT INTO t1 (c1,c2,c3) VALUES(2003,2001,2000);
88 INSERT INTO t1 (c1,c2,c3) VALUES(2004,2000,2000);
89 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000) ON DUPLICATE KEY UPDATE c3=2011;
90 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2000,2000) ON DUPLICATE KEY UPDATE c3=2011;
91 SELECT * FROM t1;
92 c1 c2 c3
93 2000 2004 2011
94 2001 2003 2000
95 2002 2002 2011
96 2003 2001 2000
97 2004 2000 2000
98 DROP TABLE t1;
99 CREATE TABLE t1(c1 DATETIME NOT NULL, c2 DATETIME NULL, c3 DATETIME NULL, PRIMARY KEY(c1), UNIQUE(c2));
100 SET TIMESTAMP=1171346973;
101 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),ADDTIME(NOW(),'4 04:01:01'),NOW());
102 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'1 01:01:01'),ADDTIME(NOW(),'3 03:01:01'),NOW());
103 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW());
104 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'3 03:01:01'),ADDTIME(NOW(),'1 01:01:01'),NOW());
105 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'4 04:01:01'),NOW(),NOW());
106 INSERT INTO t1 (c1,c2,c3) VALUES(ADDTIME(NOW(),'2 02:01:01'),ADDTIME(NOW(),'2 02:01:01'),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
107 INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE c3=ADDTIME(NOW(),'6 06:01:01');
108 SELECT * FROM t1;
109 c1 c2 c3
110 2007-02-13 09:09:33 2007-02-17 13:10:34 2007-02-19 15:10:34
111 2007-02-14 10:10:34 2007-02-16 12:10:34 2007-02-13 09:09:33
112 2007-02-15 11:10:34 2007-02-15 11:10:34 2007-02-19 15:10:34
113 2007-02-16 12:10:34 2007-02-14 10:10:34 2007-02-13 09:09:33
114 2007-02-17 13:10:34 2007-02-13 09:09:33 2007-02-13 09:09:33
115 DROP TABLE t1;
116 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NULL, c3 YEAR NULL, PRIMARY KEY(c1), UNIQUE(c2));
117 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2004,2000);
118 INSERT INTO t1 (c1,c2,c3) VALUES(2001,2003,2000);
119 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000);
120 INSERT INTO t1 (c1,c2,c3) VALUES(2003,2001,2000);
121 INSERT INTO t1 (c1,c2,c3) VALUES(2004,2000,2000);
122 INSERT INTO t1 (c1,c2,c3) VALUES(2002,2002,2000) ON DUPLICATE KEY UPDATE c3=2011;
123 INSERT INTO t1 (c1,c2,c3) VALUES(2000,2000,2000) ON DUPLICATE KEY UPDATE c3=2011;
124 SELECT * FROM t1;
125 c1 c2 c3
126 2000 2004 2011
127 2001 2003 2000
128 2002 2002 2011
129 2003 2001 2000
130 2004 2000 2000
131 DROP TABLE t1;
132 SET TIME_ZONE= @@global.time_zone;