V11.5 Release Notes

DECODE scalar function did not properly set the scale of its result

The DECODE scalar function in V11.* prior to V11.5 may not properly set the scale for numeric values. This caused a SQL statement similar to the following to return incorrect results:

SELECT DECODE('A','A',1.25,'B',2.52,3.12)

The above statement returned 1 instead of 1.25.

This behavior has been reverted to match the correct behavior of V10.