DB2 FOR LUW / DB2FORLUW / 970 - DB2

A query that specifies a fetch-first-clause may return wrong
results if there is a predicate in the same subselect.  For
example:

  SELECT ID, NAME
  FROM TABLE1
  WHERE 
  ORDER BY ID
  OFFSET ? ROWS
  FETCH NEXT ? ROWS ONLY

In some circumstances  may be applied after the
offset-clause and fetch-first-clause are processed, which
results in fewer rows than expected.

****************************************************************
* USERS AFFECTED:                                              *
* All                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description, use Local fix or upgrade to the       *
* release and fixpak that has this fix.                        *
****************************************************************
* RECOMMENDATION:                                              *
* See Error Description, use Local fix or upgrade to the       *
* release and fixpak that has this fix.                        *
****************************************************************

Move the predicate into a nested subselect, e.g.:

  SELECT ID, NAME
  FROM (SELECT ID, NAME FROM TABLE1 WHERE )
  ORDER BY ID
  OFFSET ? ROWS
  FETCH NEXT ? ROWS ONLY

not known / see Local fix

forerunner  : IT16918 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.10.2016
30.05.2017
30.05.2017