diff options
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/update.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index 71de6830963..aeb44fa4e6c 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -337,3 +337,11 @@ a b 22 3 23 3 drop table t1; +create table t1 (f1 date not null); +insert into t1 values('2000-01-01'),('0000-00-00'); +update t1 set f1='2002-02-02' where f1 is null; +select * from t1; +f1 +2000-01-01 +2002-02-02 +drop table t1; |