diff options
| author | unknown <dlenev@mysql.com> | 2004-12-30 21:18:10 +0300 |
|---|---|---|
| committer | unknown <dlenev@mysql.com> | 2004-12-30 21:18:10 +0300 |
| commit | 1ffd688a4a341157df30602a7f3c6d97f9a4e010 (patch) | |
| tree | b54b57244a10da8f91840a3a3c53989a5220db7c /mysql-test/r/func_time.result | |
| parent | 2fb340b5209dda8f71f372fed17d65a0c5814821 (diff) | |
| download | mariadb-git-1ffd688a4a341157df30602a7f3c6d97f9a4e010.tar.gz | |
Fix for bug #7515 "from_unixtime(0) now returns NULL instead of
the Epoch". (With after review fixes).
mysql-test/r/func_time.result:
Added test for bug #7515 "from_unixtime(0) now returns NULL instead of
the Epoch".
mysql-test/t/func_time.test:
Added test for bug #7515 "from_unixtime(0) now returns NULL instead of
the Epoch".
sql/item_timefunc.cc:
Item_func_from_unixtime:
from_unixtime(0) should return Epoch instead of NULL.
sql/item_timefunc.h:
Item_func_from_unixtime:
- Removed unused method definition.
- fix_length_and_dec() should set maybe_null to true since now
from_unixtime() can return NULL even in case when none of its
arguments is NULL.
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index 32034bf289d..c1e75b60e4f 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -470,9 +470,12 @@ unix_timestamp(@a) select unix_timestamp('1969-12-01 19:00:01'); unix_timestamp('1969-12-01 19:00:01') 0 -select from_unixtime(0); -from_unixtime(0) +select from_unixtime(-1); +from_unixtime(-1) NULL select from_unixtime(2145916800); from_unixtime(2145916800) NULL +select from_unixtime(0); +from_unixtime(0) +1970-01-01 03:00:00 |