IBM Support

LI75190: 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 UA
    

Local fix

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

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM 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 UA                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to Version 9.1 Fix Pack 9                             *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.1 Fix Pack 9
    

Temporary fix

  • See LOCAL FIX
    

Comments

APAR Information

  • APAR number

    LI75190

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-12-22

  • Closed date

    2010-04-13

  • Last modified date

    2010-04-13

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

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

    IC65343 IC65344

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021