|
Problem IT40905
|
Status: Closed |
INCORRECT ROW COUNT REPORTED WITH INSERT .. IGNORE DUPLICATES , COLUMNAR TABLES ONLY.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
In some case, when doing an INSERT into a COLUMNAR table with
IGNORE DUPLICATES,
Output SQLCA from INSERT counts not only inserted rows, but also
the rejected rows as inserted.
Rejected duplicate rows from external table insert with IGNORE
DUPLICATES should not be included in the rows inserted count in
SQLCA output. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* IGNORE DUPLICATES functionality. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Please, see Error Description and install the fix. *
****************************************************************
* RECOMMENDATION: *
* Please, see Error Description and install the fix. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* IGNORE DUPLICATES functionality. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Please, see Error Description and install the fix. *
****************************************************************
* RECOMMENDATION: *
* Please, see Error Description and install the fix. *
**************************************************************** |
| Comment |
Please, see Error Description and install the fix. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.05.2022
03.10.2022
03.10.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
