|
Problem IT23243
|
Status: Closed |
TRAP WHEN IN/EXISTS SUBQUERY IN SELECT LIST AND ACCESS CONTROL ACTIVATED
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Db2 query may abend if the following conditions are met:
1. There is an IN/EXISTS subquery in the select list
2. There is an access control mask set set on a column of a
table
3. There is a subselect on the table having access control
4. The masked columm is referenced multiple times in the
subselect and in the select. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* Db2 query may abend if the following conditions are met: *
* 1. There is an IN/EXISTS subquery in the select list *
* 2. There is an access control mask set set on a column of a *
* table *
* 3. There is a subselect on the table having access control *
* 4. The masked columm is referenced multiple times in the *
* subselect and in the select. *
* *
* Example: *
* create table t1(c1 int); *
* create table t2(c1 int, c2 int,c3 int); *
* create table t3(c1 int, c11 int,c2 int); *
* *
* *
* alter table t2 activate column access control; *
* CREATE MASK xx ON t2 *
* FOR COLUMN c2 RETURN CASE *
* WHEN(VERIFY_GROUP_FOR_USER(SESSION_USER,'FLTACCT')=1) THEN *
* c2 ELSE 'RESTRICTED' END *
* ENABLE; *
* *
* insert into t3 select c2, c2,case when exists(select c1 *
* from t1 where t1.c1=t2.c1) then 1 else 2 end from t2 where *
* c3=1; *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 10 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner :
follow-up : IT23245 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.11.2017
12.07.2018
12.07.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
