PM93963: INCORROUT (NO ROWS FOUND) FOR A WHERE WITH A NOT ALONG WITH SIMPLE PREDICATES THAT CAN BE PRE-EVALUATED TO FALSE OR TRUE

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 found) for a WHERE with a NOT along
    with simple predicates that can be pre-evaluated to false or
    true (i.e. 1=5).                                       (d168295)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL DB2 11 for z/OS users who use simple     *
    *                 always false predicates.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: INCORROUT on a SELECT with a NOT        *
    *                      predicate with simple always false      *
    *                      predicates.  There will be no rows      *
    *                      returned when rows should be returned.  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    INCORROUT on a SELECT with a NOT predicate and simple always
    false predicates.  No rows will be returned when rows should
    be returned.
    
    Simple Recreate:
    SELECT * FROM SYSIBM.SYSDUMMY1
      WHERE NOT (2 = 0 OR
       (3 = 0 AND 4 = 0)) ;
    

Problem conclusion

  • DB2 has been fixed to handle the NOT and simple always false
    predicates.
    
    Additional Keywords:  SQLSELECT SQLPRUNE SQLNOT
    SQLINCORR SQLINCORROUT DB2INCORR/K
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM93963

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-26

  • Closed date

    2013-09-04

  • Last modified date

    2013-10-03

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

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

    UK97314

Modules/Macros

  • DSNXOW1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UK97314

       UP13/09/20 P F309 ½

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

Document information


More support for:

DB2 for z/OS

Software version:

B10

Reference #:

PM93963

Modified date:

2013-10-03

Translate my page

Machine Translation

Content navigation