diff options
| author | evgen@moonbone.local <> | 2005-11-01 19:47:53 +0300 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2005-11-01 19:47:53 +0300 |
| commit | bbe58c7e263658ac67032782a9268c43aabc997c (patch) | |
| tree | 6c1605103b3513ebad088e2997385997cd4d354f /mysql-test/t/update.test | |
| parent | e5f48e13bfd6a792b80edc002ab3def5eb160f60 (diff) | |
| parent | 47059b89f5b78b22c5333be8dab7d8c871105d9a (diff) | |
| download | mariadb-git-bbe58c7e263658ac67032782a9268c43aabc997c.tar.gz | |
Manually merged
Diffstat (limited to 'mysql-test/t/update.test')
| -rw-r--r-- | mysql-test/t/update.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/update.test b/mysql-test/t/update.test index 9235d30c500..2a151f0dd38 100644 --- a/mysql-test/t/update.test +++ b/mysql-test/t/update.test @@ -261,4 +261,13 @@ update t1 set a=a+12,b=3 order by a limit 3; select * from t1 order by a; drop table t1; + +# +# Bug#14186 select datefield is null not updated +# +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; +drop table t1; # End of 4.1 tests |