2.0.9.16 and ROUNDP broken by fix
Posted: Thu Apr 20, 2023 1:59 am
FYI to anyone moving to 2.0.9.16 and using ROUNDDP with negative parameters.
We have just upgraded to 2.0.9.16 (Only to address vulnerability: https://www.ibm.com/support/pages/node/6856457) a few days ago and have found that our use of ROUNDP is no longer working. We are passing -2 and in cases where we have something like .0000024 as the number to be rounded we are getting crazy numbers 1,000,000 and similar . -1 is giving the same result.
In the fix notes: https://www.ibm.com/support/pages/syste ... 0916-1.pdf
I see this: "The ROUNDP function rounds 0 and null values to "10000000000000000" when the decimal precision parameter is "-2"or any lower value" with the detail in the following
https://www.ibm.com/support/pages/apar/PH52125
But it seems that their fix has broken the function.
UPDATE: IBM RESPONSE IS THAT THIS WILL BE FIXED IN 2.0.9.17
We have just upgraded to 2.0.9.16 (Only to address vulnerability: https://www.ibm.com/support/pages/node/6856457) a few days ago and have found that our use of ROUNDP is no longer working. We are passing -2 and in cases where we have something like .0000024 as the number to be rounded we are getting crazy numbers 1,000,000 and similar . -1 is giving the same result.
In the fix notes: https://www.ibm.com/support/pages/syste ... 0916-1.pdf
I see this: "The ROUNDP function rounds 0 and null values to "10000000000000000" when the decimal precision parameter is "-2"or any lower value" with the detail in the following
https://www.ibm.com/support/pages/apar/PH52125
But it seems that their fix has broken the function.
UPDATE: IBM RESPONSE IS THAT THIS WILL BE FIXED IN 2.0.9.17