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
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
