PM87166: INCORRECT OUTPUT NO ROWS RETURNED AFTER UK92607 (V10) or UK92608(V9)

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Incorrect output No rows returned after UK92607
    
    SELECT * FROM TABLE1
    WHERE 1 <> 10;
    Rows are not returned (should be, since condition is true)
    
    keywords:
    SQLINCORR INCORROUT DB2INCORR/K
    

Local fix

  • restore UK92607
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of       *
    *                 constant <> constant predicates              *
    *                 with  PM80911  applied                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Incorrect output may occur with         *
    *                      UK92607 (V10) or UK92608 (V9).          *
    *                      The non correlated SQL                  *
    *                      statement that uses constant <>         *
    *                      constant predicate where the            *
    *                      constants are integer, bigint or        *
    *                      binary and the length of the            *
    *                      constants are different may             *
    *                      receive incorrect output.               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Incorrect output may occur with UK92607 (V10) or UK92608 (V9).
    The non correlated SQL statement that uses
    constant <> constant predicate where the constants are
    integer, bigint or binary  and the length of the constants
    are different may receive incorrect output.
    
    For Example,
      SELECT 1 FROM SYSIBM.SYSDUMMY1 WHERE 1 <> 10;
    

Problem conclusion

  • DB2 was fixed to process the statement that contains a
    constant <> constant predicate where the length
    of the constants are different correctly.
    
    Additional Keywords: SQLPRUNE  SQLINCORR SQLINCORROUT
                         INCORROUT DB2INCORR/K
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM87166

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-17

  • Closed date

    2013-06-17

  • Last modified date

    2013-08-02

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

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

    UK95210 UK95214

Modules/Macros

  •    DSNXOPRU
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK95210

       UP13/07/03 P F307

  • R910 PSY UK95214

       UP13/07/03 P F307

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM87166

Modified date:

2013-08-02

Translate my page

Machine Translation

Content navigation