PH45568: SELECT WITH ORDER BY AND LIMIT AND OFFSET SQL QUERY RETURN INCORRECT ROWS

APAR status

• Closed as program error.

Error description

• A SELECT function with ORDER BY, LIMIT and OFFSET parameter is
  returning additional 1 row.
  If OFFSET value is set to ZERO, number of rows returned is
  correct (equal to LIMIT parameter).
  if OFFSET value is more than ZERO, additional 1 row is returned
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH45568                                 *
  *                      Issue with SELECT with ORDER BY         *
  *                      and LIMIT and OFFSET SQL query          *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH45568
  Issue with SELECT with ORDER BY and LIMIT and OFFSET SQL query
  

Problem conclusion

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:

Modules/Macros

• AVZCDBIF AVZO319D AVZO319N AVZO31AD AVZO31AN AVZO31BD AVZO31BN
  AVZO31CD AVZO31CN AVZO31DD AVZO31DN AVZO649D AVZO649N AVZO64AD
  AVZO64AN AVZO64BD AVZO64BN AVZO64CD AVZO64CN AVZO64DD AVZO64DN
  AVZPRIMP AVZSQ29D AVZSQ29N AVZSQ2BN AVZSQ2CN AVZSQ2DN AVZSQL9D
  AVZSQL9N AVZSQLBN AVZSQLCN AVZSQLDN
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels