diff options
| author | jani@ua72d24.elisa.omakaista.fi <> | 2004-03-09 22:03:01 +0200 |
|---|---|---|
| committer | jani@ua72d24.elisa.omakaista.fi <> | 2004-03-09 22:03:01 +0200 |
| commit | 8dcb41d8d96df9006492a1e057a79b69dff207b8 (patch) | |
| tree | be5820a74d9f1d870c2d07eb5a1c3384745dead0 /mysql-test/r/create.result | |
| parent | c3920549bd34a5f9c96cbcd2fffb55b72e044d52 (diff) | |
| download | mariadb-git-8dcb41d8d96df9006492a1e057a79b69dff207b8.tar.gz | |
Fixed Bug#3115. CAST AS DATE with malformed string returns NULL but IS NULL
is false.
Diffstat (limited to 'mysql-test/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 14 |
1 files changed, 7 insertions, 7 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 |