DB2 FOR LUW / DB2FORLUW / 950 - DB2

When the SELECT list of a result table of a SET operator (e.g. 
UNION ALL, INTERSECT, etc.) references an inline SQL function 
with a scalar aggregate function as input argument, DB2 may 
return SQL0421N or terminate abnormally (SQL1224N). 
 
 
When SQL1224N is returned, the trap file will contain the 
following stack: 
 
Signal #11 
 
sqlnq_sem 
sqlnp_smactn 
sqlnp_parser 
sqlnp_main 
sqlnn_cmpl 
sqlnn_cmpl 
sqlra_compile_var 
sqlra_find_var 
sqlra_get_var 
sqlri_ddl_get_section 
sqlri_ddl_common 
.... 
.... 
 
Examples: 
 
CREATE FUNCTION lws.GETDOCID(docid VARCHAR(254)) RETURNS 
VARCHAR(319) 
LANGUAGE SQL 
NO EXTERNAL ACTION 
DETERMINISTIC 
RETURN CONCAT(CONCAT('{DOCID$',docid), '}') ; 
 
-- Example 1: SQL0421N 
SELECT 'foo' as key 
   FROM sysibm.sysdummy1 
UNION ALL 
SELECT lws.GETDOCID(CHAR(ROW_NUMBER() OVER())) AS key 
   FROM sysibm.sysdummy1; 
 
 
-- Example 2: SQL1224N 
 SELECT lws.GETDOCID(CHAR(ROW_NUMBER() OVER())) AS key 
   FROM sysibm.sysdummy1 
UNION ALL 
 SELECT 'foo' as key 
   FROM sysibm.sysdummy1 ;

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See ERROR DESCRIPTION.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply v9.5 Fixpack 8 to the server.                          * 
****************************************************************

DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in v9.5 Fixpack 8. At minimum this fix should be 
applied to the server side.

not known / see Local fix

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

12.01.2011
27.06.2011
27.06.2011

9.5.FP8