mysql-test/main/adddate_454.result


1
2
3
4
5
6
7
8
9
10
11
12

create table t1 (d date);
insert into t1 values ('2012-00-00');
select * from t1;
d
2012-00-00
update ignore t1 set d = adddate(d, interval 1 day);
Warnings:
Warning	1292	Incorrect datetime value: '2012-00-00'
select * from t1;
d
NULL
drop table t1;