[DERBY-729] Scalar time and date functions return 0 instead NULL when argument is NULL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.3.2, 10.2.1.6
• Fix Version/s: 10.3.1.4
• Component/s: SQL
• Issue & fix info: Release Note Needed
• Assignee: Bernt Johnsen
• Reporter: Bernt Johnsen
• Created: 28/Nov/05 22:58
• Updated: 21/Jan/11 17:48
• Resolved: 26/May/07 22:55

Description

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.