PK94824: INCORROUT WHEN SELECT COUNT (DISTINCT) ON DECIMAL FLOAT EXPRESSIONS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • incorrect output can be received when Select Count (Distinct) on
    Decimal Float expressions.
    
    Additional keyword: SQLINCORROUT DECFLOAT
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS users when running        *
    *                 query containing aggregate functions with    *
    *                 DISTINCT() and ALL() on the same decimal     *
    *                 float expressions.                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: Incorrect output may be returned for    *
    *                      query containing aggregate functions    *
    *                      with DISTINCT() and ALL() on the same   *
    *                      decimal float expressions.              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Incorrect output may be returned for query containing aggregate
    functions with DISTINCT() and ALL() on the same decimal float
    expressions.
    
    The following query is an example of this case.
    
      SELECT
         COUNT(DISTINCT(DECFLOAT_1 + DECFLOAT_2)),
         COUNT(ALL(DECFLOAT_1 + DECFLOAT_2))
      FROM T1;
    

Problem conclusion

  • The code in DB2 is modified to correct the failing condition.
    
    Additional keyword: SQLCOUNT SQLDISTINCT SQLALL SQLINCORR
                        INCORROUT DB2INCORR/K SQLAVG SQLMAX SQLMIN
                        SQLSUM
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PK94824

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-26

  • Closed date

    2011-08-23

  • Last modified date

    2011-10-03

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

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

    UK71148

Modules/Macros

  •    DSNXOSEP DSNXOSR  DSNXRCSF DSNXRESF DSNXRGBJ
    DSNXRRSQ DSNXRSFJ DSNXRSFN DSNXRSGB DSNXRSJ
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK71148

       UP11/09/08 P F109

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:

910

Reference #:

PK94824

Modified date:

2011-10-03

Translate my page

Machine Translation

Content navigation