DB2 FOR LUW / DB2FORLUW / A10 - DB2

Under rare scenarios DB2 might produce SQL0901N if the
following conditions are true:
1) One or more tables in the query have Row and Column Access
Control (RCAC) declared on them
2) One or more of the columns on which a RCAC mask is declared
are marked as not nullable
3) The table(s) are referenced in the null-producing side of a
left outer join

Example:
create Table T2(key varchar(8) not null, c1 int);
CREATE MASK MASK_KEY ON T2 FOR COLUMN "KEY" RETURN case when
VERIFY_ROLE_FOR_USER(SESSION_USER,'CONFIDENTIAL')=1  THEN KEY
else 'xxxxxxxx' END  ENABLE;

select * from T1 left join T2 on t1.c1 = t2.c1;

SQL0901N  The SQL statement or command failed because of a
database system
error. (Reason "unexpected type".)  SQLSTATE=58004


sqlns_qgs
sqlnq_compile_fgac
sqlnq_apply_column_level_access_control
sqlnq_apply_column_read_level_access_control
sqlnq_identify_mask_location
sqlnq_fun_tres
sqlnq_fun_res_walk
sqlnq_encap_doit
sqlnq_encap_cast_rtn
sqlnq_encap_cast_check_char_len

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 10.1 Fix Pack 5                               *
****************************************************************

not known / see Local fix

forerunner  : IT01954 
follow-up : 

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

06.03.2017
03.05.2017
03.05.2017