IBM Support

IT25706: INCORRECT RESULTS COULD HAPPEN WITH OUTER JOINS AND EXPRESSIONS IN JOIN COLUMNS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Users might observe incorrect results when running a query with
    the following characteristics:
    1. the query has an outer join
    2. the outer join columns contain expressions
    3. the row preserving side of the outer join has a GB or UNION
    4. the null producing side of the outer join has a GB, UNION or
    CSE
    5. there is at least one outer join predicate referencing only
    the null producing columns
    
    The wrong result set usually contains less rows than the correct
    result set.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * INCORRECT RESULTS WITH OUTER JOINS AND EXPRESSIONS IN JOIN   *
    * COLUMNS                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 mod 4 fixpack 4 or later                 *
    ****************************************************************
    

Problem conclusion

  • Fixed in Db2 11.1 mod 4 fixpack 4 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT25706

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-07-16

  • Closed date

    2018-11-29

  • Last modified date

    2018-11-29

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

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

    IT25735

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 November 2018