DB2 FOR LUW / DB2FORLUW / 910 - DB2

A query containing a predicate of the form "<CONCAT expression> 
= G'constant'" may return wrong results.  The CONCAT expression 
must be a concatenation of one or more GRAPHIC columns or 
GRAPHIC constants and the result size of each side of the 
predicate must be the same.  Here are some examples of 
problematic queries: 
 
          CREATE TABLE T1 ( G1 GRAPHIC(4), G2 GRAPHIC(3)) ); 
 
SELECT * FROM T1 WHERE ( G1|| G2 ) = G'ABCDXYZ'; 
SELECT * FROM T1 WHERE G'ABCDXYZ' = ( G'ABCD' || G2 )

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query containing a predicate of the form "<CONCAT          * 
* expression> = G'constant'" may return wrong results.  The    * 
* CONCAT expression must be a concatenation of one or more     * 
* GRAPHIC columns or GRAPHIC constants and the result size of  * 
* each side of the predicate must be the same.  Here are some  * 
* examples of problematic queries:                             * 
*                                                              * 
* CREATE TABLE T1 ( G1 GRAPHIC(4), G2 GRAPHIC(3)) );           * 
*                                                              * 
* SELECT * FROM T1 WHERE ( G1|| G2 ) = G'ABCDXYZ';             * 
*                                                              * 
* SELECT * FROM T1 WHERE G'ABCDXYZ' = ( G'ABCD' || G2 )        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version Fix Pack 10                           * 
****************************************************************

Add one or more trailing spaces to the GRAPHIC constant side of 
the predicate: 
 
SELECT * FROM T1 WHERE ( G1 || G2 ) = G'ABCDXYZ     '; 
SELECT * FROM T1 WHERE G'ABCDXYZ    ' = ( G'ABCD' || G2 )

DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

First Fixed in DB2 Version Fix Pack 10

N/A

N/A

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

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

17.03.2010
16.06.2011
16.06.2011