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 | |
| 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')
| -rw-r--r-- | mysql-test/r/create.result | 14 | ||||
| -rw-r--r-- | mysql-test/r/func_sapdb.result | 10 |
2 files changed, 12 insertions, 12 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index e6a010a7542..4cb57a43cf3 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -104,9 +104,9 @@ drop table t2; create table t2 select CAST("2001-12-29" AS DATE) as d, CAST("20:45:11" AS TIME) as t, CAST("2001-12-29 20:45:11" AS DATETIME) as dt; describe t2; Field Type Null Key Default Extra -d date 0000-00-00 -t time 00:00:00 -dt datetime 0000-00-00 00:00:00 +d date YES NULL +t time YES NULL +dt datetime YES NULL drop table t1,t2; create table t1 (a tinyint); create table t2 (a int) select * from t1; @@ -396,12 +396,12 @@ Field Type Null Key Default Extra a int(11) YES NULL b bigint(11) 0 c bigint(10) 0 -d date 0000-00-00 +d date YES NULL e char(1) -f datetime 0000-00-00 00:00:00 -g time 00:00:00 +f datetime YES NULL +g time YES NULL h longblob -dd time 00:00:00 +dd time YES NULL select * from t2; a b c d e f g h dd 1 -7 7 2000-01-01 b 2000-01-01 00:00:00 05:04:03 yet another binary data 02:00:00 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 |