DB2 FOR LUW / DB2FORLUW / A50 - DB2

A NULL value is incorrectly inserted into a column of a 
column-organized table when the VALUES clause contains an 
expression with a term, from the table being inserted into, that 
is a scalar subselect. 
 
For example, after executing the following SQL statements, the 
table should contain the values (1) and (2), but the table 
contains the values (1) and (NULL) instead: 
 
create table t1 (i1 int) organize by column; 
insert into t1 values (1); 
insert into t1 values ((select i1 from t1)+1);

**************************************************************** 
* USERS AFFECTED:                                              * 
* The problem only affects column-organized tables.            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5.0.4.                             * 
****************************************************************

Assign the values using scalar subselect to a variable first and 
then insert the row using that variable.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

The problem is first fixed in DB2 version 10.5.0.4.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.03.2014
08.09.2014
07.04.2015