Informix - Problem description
Problem IT37421 | Status: Closed |
Wrong result for aggregate query via index - MIN for example - when NULL contained in column alongside non-NULL data | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When a select min ( column ) is used and the table contains a NULL value in the result set, the query returns different results depending on using a sequential scan or a index scan select --+ index ( t1 ) nvl(min(b),'isnull') from t1 where a in (2,3); select --+ full ( t1 ) nvl(min(b),'isnull') from t1 where a in (2,3); (expression) isnull 1 row(s) retrieved. (expression) 2 1 row(s) retrieved. This problem started appearing in 12.10.xC14 and 14.10.xC4. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server 12.10.xC14 and 14.10.xC4 - xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when * * available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server 12.10.xC14 and 14.10.xC4 - xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 or 14.10.xC7 (when * * available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.06.2021 31.08.2021 31.08.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |