summaryrefslogtreecommitdiff
path: root/mysql-test/r/update.result
diff options
context:
space:
mode:
authorunknown <evgen@moonbone.local>2005-11-01 19:47:53 +0300
committerunknown <evgen@moonbone.local>2005-11-01 19:47:53 +0300
commit70536ba1b5b4c8e81f71b714112b42ff3fcc3f5e (patch)
tree6c1605103b3513ebad088e2997385997cd4d354f /mysql-test/r/update.result
parentee380a077782f87d80aae7a8c9c9ead51dfd8e7b (diff)
parent03ed0d1d244de2e97c1ca5749f1677d1dbb07f95 (diff)
downloadmariadb-git-70536ba1b5b4c8e81f71b714112b42ff3fcc3f5e.tar.gz
Manually merged
client/mysqltest.c: Auto merged myisam/mi_check.c: Auto merged mysql-test/r/update.result: Auto merged mysql-test/t/update.test: Auto merged sql/item_timefunc.h: Auto merged sql/spatial.cc: Auto merged sql/sql_select.h: Auto merged BitKeeper/deleted/.del-acinclude.m4~f4ab416bac5003: Auto merged
Diffstat (limited to 'mysql-test/r/update.result')
-rw-r--r--mysql-test/r/update.result8
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;