IC71315: NO RESULTS ARE RETURNED WITH A SELECT MAX() QUERY IF THE TABLE HAS A COMPOSITE INDEX WITH 'DESC' KEYWORD.

APAR status

• Closed as program error.

Error description

• After upgrading from 11.50.xC5 to 11.50.xC7 you see that a
  "Select MAX() " query on a table with a composite index and a
  'DESC' (descending order) keyword that used to return results;
  now returns nothing.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of 11.50.xC7.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query selecting MAX may return incorrect result if all of  *
  * the following conditions are met:                            *
  *  - query uses a composite index, e.g. index on tab(c1, c2    *
  * desc)                                                        *
  *  - a non-leading index column is defined in descending order *
  * (e.g. c2 above)                                              *
  *  - query select MAX(c2)                                      *
  *  - query has an equality predicate on c1, and a greater-than *
  * predicate on c2, e.g., c1 = 5 and c2 > 0                     *
  ****************************************************************
  * 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