diff options
| author | unknown <jani@ua72d24.elisa.omakaista.fi> | 2004-03-09 22:03:01 +0200 |
|---|---|---|
| committer | unknown <jani@ua72d24.elisa.omakaista.fi> | 2004-03-09 22:03:01 +0200 |
| commit | 53b3ebdfe0e589721803a5306b14455efcb7adda (patch) | |
| tree | be5820a74d9f1d870c2d07eb5a1c3384745dead0 /mysql-test/r/func_sapdb.result | |
| parent | 23f9f229d422db7ee55ecb42c93e69da45dd9e51 (diff) | |
| download | mariadb-git-53b3ebdfe0e589721803a5306b14455efcb7adda.tar.gz | |
Fixed Bug#3115. CAST AS DATE with malformed string returns NULL but IS NULL
is false.
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test/r/func_sapdb.result')
| -rw-r--r-- | mysql-test/r/func_sapdb.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/func_sapdb.result b/mysql-test/r/func_sapdb.result index e330c73727b..38bd73bca0f 100644 --- a/mysql-test/r/func_sapdb.result +++ b/mysql-test/r/func_sapdb.result @@ -159,14 +159,14 @@ time("1997-12-31 23:59:59.000001") as f9; describe t1; Field Type Null Key Default Extra f1 date 0000-00-00 -f2 datetime 0000-00-00 00:00:00 -f3 time 00:00:00 +f2 datetime YES NULL +f3 time YES NULL f4 time 00:00:00 f5 time 00:00:00 f6 time 00:00:00 -f7 datetime 0000-00-00 00:00:00 -f8 date 0000-00-00 -f9 time 00:00:00 +f7 datetime YES NULL +f8 date YES NULL +f9 time YES NULL select * from t1; f1 f2 f3 f4 f5 f6 f7 f8 f9 1997-01-01 1998-01-02 01:01:00 49:01:01 46:58:57 -23:59:59 10:11:12 2001-12-01 01:01:01 1997-12-31 23:59:59 |