|
Problem IT12541
|
Status: Closed |
WITH THE FIX OF IT10301 THE ENGINE CAN FALSELY REPORT ERROR -692WHILE DELETING FROM A TEMP TABLE WITH UNIQUE OR PK CONSTRAINT
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
If you run IBM Informix Server version which contains the fix
for APAR IT10301 and you use temporary tables with
a unique or a primary key constraint defined, the engine may
report the error -692 ( Key value for constraint (on table
) is still being referenced.) when you do a delete from
such a temp table.
The fix of IT10301 changed the way the constrid for constraints
in temp tables are assigned - instead of using the next serial
value from the sysconstraints system catalog a session's
internal counter is now used. For each session this counter
starts from 0. The problem occurs when the constrid generated by
this counter matches a constrid of some PK constraint defined in
the sysconstraints system catalog. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Temporary tables with a unique or a primary key constraint *
* defined, may receive -692 while using that temp table. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 11.70.xC9 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.12.2015
09.06.2017
09.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
11.70.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
