|
Problem IT23245
|
Status: Closed |
TRAP WHEN IN/EXISTS SUBQUERY IN SELECT LIST AND ACCESS CONTROL ACTIVATED
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - 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: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : IT23243
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.11.2017
27.11.2018
27.11.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
