IT07804: SETTING IFX_FOLDVIEW TO 1 RETURNS WRONG RESULTS FOR SELECT COUNT(DISTINCT)

APAR status

• Closed as program error.

Error description

• With IFX_FOLDVIEW set to 1, wrong results are returned for a
  select count(distinct) statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of 12.10.xC1 through 12.10.xC5.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query involving a UNION ALL view may return incorrect      *
  * results under the following conditions:                      *
  *   - a simple UNION ALL view, with each arm of the view       *
  * having a single table, and no group by, aggregation          *
  *   - main query is selecting form the UNION ALL view, with no *
  * group by                                                     *
  *   - an aggregate with DISTINCT (e.g. count(distinct column)) *
  * in the main query                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC6.                     *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC6.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels