|
Problem IT28478
|
Status: Closed |
SELECT IN AN SP CALLED FROM AN UPDATE TRIGGER USING THE SAME TABLE AS THE UPDATE WAS ISSUED IN RETURNS NOW ERROR 522
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
There is the following call logic
Table -> update trigger using definitions of new and old -> SP
an update is initiated on the base table
In the SP there is a select included, using the same table
as the table where the trigger was started from. The select
itself used clear names of the table not the names from
old and new.
This worked in the versions before of 12.10.FC12 now it
returns an error -522 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Select in an SP called from an update trigger using the same *
* table as the update was issued in returns error 522. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.03.2019
24.09.2019
24.09.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC13
|
| Problem solved according to the fixlist(s) of the following version(s) |
