Informix - Problembeschreibung
Problem IT27545 | Status: Geschlossen |
WRONG NUMBER OF TOTAL INSERTED/UPDATED ROW COUNT RETURNED WHEN AN INSERT/UPDATE IS MADE ON A TABLE THAT USES A TRIGGER | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
When a row is inserted/updated on a Secondary Server on a table that uses a trigger to insert/update on another table the operation works successfully but number of rows returned is wrong. For example, if an insert of just one row is made on Primary server, it returns the correct number of rows : $ dbaccess ts128026db count_rows.sql Database selected. empenio 1 1 row(s) retrieved. movimiento 1 1 row(s) retrieved. Database closed. But if same insert of just one row is made on an updatable secondary it returns ; dbaccess ts128026db insert_dsd.sql Database selected. 0 row(s) inserted. Database closed. However, the operation was successful and the two tables have correct number of rows but the SQL returns a wrong number of rows processed. The number of rows returned are used by applications so they are behaving in a wrong way when they are executed against a secondary server. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC11 and older versions. * **************************************************************** * PROBLEM DESCRIPTION: * * Wrong number of total inserted/updated row count returned * * when an insert/update is made on a updatable secondary * * server on a table that uses a trigger. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.12.2018 07.10.2019 07.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC12 | |
Problem behoben lt. FixList in der Version |