RE: SAPDB DECODE statement problem

Kevin Heil wrote:
> Hello,
> 
> I have been having a problem using the DECODE statement in 
> SQL.  It seems 
> that when I use the decode statement on a floating-point column, it 
> truncates the result.  I cannot figure out a way around this. 
>  An example 
> SQL statement is:
> 
> SELECT DECODE(T.COL1, null, 0, T.COL1) NEW_COL
> FROM TABLEA T;
> 
> If, for example, T.COL1 is 4.77, the result is "4".  If the 
> T.COL1 is null, 
> 0 appears correctly.
> 
> Has anyone experienced this before?

As mentioned in earlier mails:

VALUE (T.COL1, 0)
is THE function to convert the NULL-value to another one (more convenient
for summing_up or the like), without changes to other values of that column.

Yes, this behaviour mentioned above is a bug, which of course
will be fixed with the next version, see PTS 1123807.

Thank you for reporting

Elke
SAP Labs Berlin