Informix - Problem description
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) |