INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

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.

****************************************************************
* 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:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.12.2018
07.10.2019
07.10.2019

12.10.xC12