IC70291: A QUERY RETURNS INCORRECT RESULT AFTER UPDATE STATISTICS MEDIUM IS RAN.

APAR status

• Closed as program error.

Error description

• A query returns only one row after update statistics medium is
  ran. It is an incorrect result as multiple rows should be
  returned. This problem does not appear when the query is
  executed just after loading data into a table and running update
  statistics low.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All 11.50 users.                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query using index self-join may return wrong result under  *
  * the following conditions:                                    *
  *   - a composite index is used                                *
  *   - the asending/descending nature of the last index key     *
  * used in the index scan is different than the last index      *
  * self-join key                                                *
  *      for example, given an index on (c1, c2 desc), if an     *
  * index self-join path is chosen on this index with (c1) as    *
  * index self-join key,                                         *
  *      then it satisfy this condition since c1 (last index     *
  * self-join key) is ascending, but c2 (last index key used) is *
  * descending                                                   *
  *   - a range predicate exists on the last index self-join key *
  * (e.g., c1 > 100)                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC8.                                        *
  ****************************************************************
  

Problem conclusion

• The problem is fixed in 11.50.xC8.
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP