You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mike Matrigali (JIRA)" <de...@db.apache.org> on 2006/01/23 20:43:11 UTC
[jira] Updated: (DERBY-729) Scalar time and date functions return
NULL when argument is NULL
[ http://issues.apache.org/jira/browse/DERBY-729?page=all ]
Mike Matrigali updated DERBY-729:
---------------------------------
Component: SQL
> Scalar time and date functions return NULL when argument is NULL
> ----------------------------------------------------------------
>
> Key: DERBY-729
> URL: http://issues.apache.org/jira/browse/DERBY-729
> Project: Derby
> Type: Bug
> Components: SQL
> Reporter: Bernt M. Johnsen
>
> The scalar time and date functions should return NULL when argument is NULL.
> Sample ij run that reproduces the bug
> ij> create table dt (ts timestamp);
> 0 rows inserted/updated/deleted
> ij> insert into dt values ({ts '2005-11-28 14:49:40'}), (NULL);
> 2 rows inserted/updated/deleted
> ij> select * from dt;
> TS
> --------------------------
> 2005-11-28 14:49:40.0
> NULL
>
> 2 rows selected
> ij> select {fn hour(ts)} from dt;
> 1
> -----------
> 14
> 0
> might be a problem with other scalar functions too.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira