DB2 FOR LUW / DB2FORLUW / 970 - DB2

CLPPLus displays different result sets only when I change the 
predicate order within the where clause for character columns 
selected with LIKE '%1' or LIKE '%2'. 
 
SQL> create table test1 ( i int , text varchar(10) ) ; 
 
DB250000I: Der Befehl wurde erfolgreich ausgefﾁhrt. 
 
SQL> insert into test1 values (1, 'Text1'), (2, 'Text2') ; 
 
DB250000I: Der Befehl wurde erfolgreich ausgefﾁhrt. 
 
SQL> select * from test1 where i = 1 or i = 2 ; 
 
          I TEXT 
----------- ---------- 
          1 Text1 
          2 Text2                              CORRECT RESULT 
ROWS! 
 
SQL> select * from test1 where text like '%1' or text like '%2' 
; 
 
          I TEXT 
----------- ----------                         INCORRECT 
RESULTSET!!! 
         1 Text1                                   => ONLY Row 
(1, ?Text1?) is returned and not (2, ?Text2?) -> Must also 
displayed in the result set 
 
SQL> select * from test1 where text like '%2' or text like '%1' 
; 
 
          I TEXT 
----------- ----------                         INCORRECT 
RESULTSET!!! 
          2 Text2                                   => ONLY Row 
(2, ?Text2?) is returned and not (1, ?Text1?) -> Must also 
displayed in the result set 
 
 
 
 
When the same SQLs are issued on the command line or Data Studio 
the results are correct! 
 
db2blu01@vmdb202:~> db2 "select * from test1 where i = 1 or i = 
2 " 
 
I           TEXT 
----------- ---------- 
          1 Text1 
          2 Text2 
 
  2 record(s) selected. 
 
db2blu01@vmdb202:~> db2 "select * from test1 where text like 
'%1' or text like '%2' " 
 
I           TEXT 
----------- ---------- 
          1 Text1 
          2 Text2 
 
  2 record(s) selected. 
 
db2blu01@vmdb202:~> db2 "select * from test1 where text like 
'%2' or text like '%1' " 
 
I           TEXT 
----------- ---------- 
          1 Text1 
          2 Text2 
 
  2 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* CLPPlus on all platforms                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in Version 9.7 Fix Pack 9.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC97838 IC97852 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

07.11.2013
16.12.2013
16.12.2013

9.7.FP9