PI61256: AE PI56200 FIX COMPLETION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• AE PI56200 fix completion.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL DB2 11 for z/OS user of SQL statement    *
  *                 with multiple OR predicates.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: An incorrect output may be met when a   *
  *                      query statement satisfies all of the    *
  *                      following conditions:                   *
  *                      1. The query contains multiple OR       *
  *                         predicates;                          *
  *                      2. There are multiple SUBSTR statements *
  *                         statements which start from position *
  *                         1;                                   *
  *                      3. At least one of the multiple SUBSTR  *
  *                         statements is always false           *
  *                         predicate.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An incorrect output may be met for SQL statement when the query
  contains multiple OR predicates, with multiple SUBSTR statements
  which start from position 1 and at least one of the SUBSTR
  statements is always false predicate.
  
  For example:
  CREATE TABLE Q1(COL1 CHAR(9) NOT NULL);
  INSERT INTO Q1 VALUES ('ABCDEFGHI');
  
  SELECT * FROM Q1
  WHERE    (SUBSTR(COL1,1,1) = 'ABCD') OR
           (SUBSTR(COL1,1,2) = 'ABCD') OR
           (SUBSTR(COL1,1,3) = 'ABCD') OR
           (SUBSTR(COL1,1,4) = 'ABCD') ;
  
  Keyword: SQLINCORR INCORROUT SQLINCORROUT SQLOR DB2INCORR/K
  

Problem conclusion

• DB2 is modified correctly to handle above incorrect output issue
  when the query contains multiple OR predicates, and there are
  multiple SUBSTR statements which start from position 1 and at
  least one of the multiple SUBSTR statements always false
  predicate.
  

Temporary fix

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

Comments

APAR Information

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

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

  UI38977

Modules/Macros

• DSNXOSP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI38977

     UP16/08/17 P F608 Ž

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.