summaryrefslogtreecommitdiff
path: root/mysql-test/main/adddate_454.test
blob: bbdd89b583d9fa89faad77a3da470c36fd28445d (plain)
1
2
3
4
5
6
7
8
9
#
# MDEV-454 Addition of a time interval reduces the resulting value
#
create table t1 (d date);
insert into t1 values ('2012-00-00');
select * from t1;
update ignore t1 set d = adddate(d, interval 1 day);
select * from t1;
drop table t1;