summaryrefslogtreecommitdiff
path: root/mysql-test/main/datetime_456.test
blob: 0c187959d5299137688c9ecd6e0b6d930017585e (plain)
1
2
3
4
5
6
7
8
#
# MDEV-456 An out-of-range datetime value (with a 5-digit year) can be created and cause troubles
#
create table t1 (d datetime);
insert t1 values (addtime('9999-12-31 23:59:59', '00:00:01')),
                 (from_days(3652499));
select * from t1;
drop table t1;