IBM Support

IC65343: WRONG RESULTS MAY OCCUR IF THE QUERY CONTAINS EXISTENTIAL SUBQUE RIES AND A CORRELATED UNION ALL CONSUMED IN THE SAME SUBSELECT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Wrong results have been noted on all version of DB2 if the
    following conditions are true:
    
    1. There are two or more existential subqueries present in the
    query.
    2. There is a UNION ALL with the following characterstics:
       a. One arm of the UNION ALL has less number of tables as
    compared to other arm(s)
       b. The UNION ALL is correlated to the subqueries.
    3. The existential subqueries are consumed in the same subselect
    that consumes the Union All
    

Local fix

  • Change the value of CURRENT QUERY OPTIMIZATION special register
    to 0
    SET CURRENT QUERY OPTIMIZATION 0;
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users using subqueries and union all views in            *
    * theirqueries                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Wrong results have been noted on all version of DB2 if       *
    * thefollowing conditions are true:1. There are two or more    *
    * existential subqueries presentinthe query.2. There is a      *
    * UNION ALL with the following characterstics:a. One arm of    *
    * the UNION ALL has less number of tables ascompared to other  *
    * arm(s)b. The UNION ALL is correlated to the subqueries.3.    *
    * The existential subqueries are consumed in the samesubselect *
    * that consumes the Union All                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to Version 9.5 Fix Pack 6                             *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65343

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-12-29

  • Closed date

    2010-05-25

  • Last modified date

    2010-05-25

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

    LI75190

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 May 2010