Informix - Problem description
Problem IT42333 | Status: Closed |
CALCULATION WITH DECIMAL WHEN RESULT IS 0 MAY CREATE A WRONG RESULT | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
A SELECT SUM(insur / change) results in 0. But select case when vol_cu::DEC(24,8) == 0 then "vol_cu is 0 " else "vol_cu is not 0" end from temp_1; select case when vol_cu == 0 then "vol_cu is 0 " else "vol_cu is not 0" end from temp_1; gives (expression) vol_cu is 0 (expression) vol_cu is not 0 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * IDS-14.10.XC9 onwards * **************************************************************** * PROBLEM DESCRIPTION: * * calculation with decimal when result is 0 may create a wrong * * result * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * IDS-14.10.XC9 onwards * **************************************************************** * PROBLEM DESCRIPTION: * * calculation with decimal when result is 0 may create a wrong * * result * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Comment | |
The server is operating correctly. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.10.2022 28.11.2022 24.02.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |