19
19
insert into t1 (t) values (991231235959);
20
20
insert into t1 (t) values (10000101000000);
21
21
insert into t1 (t) values (99991231235959);
22
--error 1686 # Bad datetime
22
--error ER_INVALID_DATETIME_VALUE # Bad datetime
23
23
insert into t1 (t) values (20030100000000);
24
--error 1686 # Bad datetime
24
--error ER_INVALID_DATETIME_VALUE # Bad datetime
25
25
insert into t1 (t) values (20030000000000);
27
--error 1686 # Bad datetime
27
--error ER_INVALID_DATETIME_VALUE # Bad datetime
28
28
delete from t1 where t > 0;
29
29
# try earliest datetime end point which is actually a friggin datetime, not a 0.
30
30
delete from t1 where t > "0001-01-01 00:00:00";
35
35
insert into t1 (t) values("691231");
36
36
insert into t1 (t) values("700101");
37
37
insert into t1 (t) values("991231");
38
--error 1686 # Bad datetime
38
--error ER_INVALID_DATETIME_VALUE # Bad datetime
39
39
insert into t1 (t) values("00000101");
40
40
insert into t1 (t) values("00010101");
41
41
insert into t1 (t) values("99991231");
42
--error 1686 # Bad datetime
42
--error ER_INVALID_DATETIME_VALUE # Bad datetime
43
43
insert into t1 (t) values("00101000000");
44
--error 1686 # Bad datetime
44
--error ER_INVALID_DATETIME_VALUE # Bad datetime
45
45
insert into t1 (t) values("691231000000");
46
--error 1686 # Bad datetime
46
--error ER_INVALID_DATETIME_VALUE # Bad datetime
47
47
insert into t1 (t) values("700101000000");
48
--error 1686 # Bad datetime
48
--error ER_INVALID_DATETIME_VALUE # Bad datetime
49
49
insert into t1 (t) values("991231235959");
50
50
insert into t1 (t) values("10000101000000");
51
51
insert into t1 (t) values("99991231235959");
52
--error 1686 # Bad datetime
52
--error ER_INVALID_DATETIME_VALUE # Bad datetime
53
53
insert into t1 (t) values("20030100000000");
54
--error 1686 # Bad datetime
54
--error ER_INVALID_DATETIME_VALUE # Bad datetime
55
55
insert into t1 (t) values("20030000000000");
58
--error 1686 # Bad datetime
58
--error ER_INVALID_DATETIME_VALUE # Bad datetime
59
59
insert into t1 (t) values ("2003-003-03");
61
61
# Bug #7308: ISO-8601 date format not handled correctly
62
--error 1686 # Bad datetime
62
--error ER_INVALID_DATETIME_VALUE # Bad datetime
63
63
insert into t1 (t) values ("20030102T131415");
64
64
insert into t1 (t) values ("2001-01-01T01:01:01");
65
--error 1686 # Bad datetime
65
--error ER_INVALID_DATETIME_VALUE # Bad datetime
66
66
insert into t1 (t) values ("2001-1-1T1:01:01");
69
69
# Test some wrong dates
71
--error 1686 # Bad datetime
71
--error ER_INVALID_DATETIME_VALUE # Bad datetime
72
72
insert into t1 (t) values("2003-0303 12:13:14");
124
124
# warnings (for both strings and numbers)
126
126
create table t1 (t datetime primary key);
127
--error 1686 # Bad datetime
127
--error ER_INVALID_DATETIME_VALUE # Bad datetime
128
128
insert into t1 values (20030102030460),(20030102036301),(20030102240401),
129
129
(20030132030401),(20031302030401),(100001202030401);
130
130
select * from t1;
132
--error 1686 # Bad datetime
132
--error ER_INVALID_DATETIME_VALUE # Bad datetime
133
133
insert into t1 values
134
134
("2003-01-02 03:04:60"),("2003-01-02 03:63:01"),("2003-01-02 24:04:01"),
135
135
("2003-01-32 03:04:01"),("2003-13-02 03:04:01"), ("10000-12-02 03:04:00");
136
136
select * from t1;
138
--error 1686 # Bad datetime
138
--error ER_INVALID_DATETIME_VALUE # Bad datetime
139
139
insert into t1 values ("0000-00-00 00:00:00 some trailer"),("2003-01-01 00:00:00 some trailer");
140
140
select * from t1 order by t;
148
148
# These dates should be treated as dates in 21st century
149
149
insert into t1 values ("12-01-01"), ("01-01-01 01:00:00");
150
150
# Zero dates are still special :/
151
--error 1686 # Yeah special uh no its wrong
151
--error ER_INVALID_DATETIME_VALUE # Yeah special uh no its wrong
152
152
insert into t1 values ("00-00-00"), ("00-00-00 00:00:00");
153
153
select * from t1;
190
190
insert into t1 (da, dt) values ('2007-03-23 13:49:38','2007-03-23 13:49:38');
191
191
insert into t1 set dt='2007-03-23 13:49:38',da=dt;
192
192
# Test error handling
193
--error 1686 # Bad date
193
--error ER_INVALID_DATETIME_VALUE # Bad date
194
194
insert into t1 (da, dt) values ('2007-03-32','2007-03-23 13:49:38');
195
195
select da,dt from t1;
197
--error 1686 # Bad datetime
197
--error ER_INVALID_DATETIME_VALUE # Bad datetime
198
198
create table t1 (da date default '1962-03-32 23:33:34', dt datetime default '1962-03-03', pk int auto_increment primary key);
273
273
create table t1(f1 datetime primary key);
274
274
insert into t1 values('2001-01-01'),('2002-02-02');
275
275
select * from t1 where f1 between 20020101 and 20070101000000;
276
--error 1686 # 2002010 is not a datetime.
276
--error ER_INVALID_DATETIME_VALUE # 2002010 is not a datetime.
277
277
select * from t1 where f1 between 2002010 and 20070101000000;
278
--error 1686 # 2007010100000 is not a datetime.
278
--error ER_INVALID_DATETIME_VALUE # 2007010100000 is not a datetime.
279
279
select * from t1 where f1 between 20020101 and 2007010100000;
330
330
insert into t1 (da, dt) values ('2007-03-23 13:49:38','2007-03-23 13:49:38');
331
331
insert into t1 set dt='2007-03-23 13:49:38',da=dt;
332
332
# Test error handling
333
--error 1686 # Bad date
333
--error ER_INVALID_DATETIME_VALUE # Bad date
334
334
insert into t1 (da, dt) values ('2007-03-32','2007-03-23 13:49:38');
335
335
select da,dt from t1;
337
--error 1686 # Bad date
337
--error ER_INVALID_DATETIME_VALUE # Bad date
338
338
create table t1 (da date default '1962-03-32 23:33:34', dt datetime default '1962-03-03' primary key);