DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* Users using CLPPlus.                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fix Pack 4.                      * 
****************************************************************

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 10.1 Fix Pack 4.

keiner bekannt / siehe Local-Fix

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

21.11.2013
02.06.2014
02.06.2014