INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Take the following test case:

create table t1 (c1 int, c2 char(4)) lock mode row;
create unique index t1_idx1 on t1(c1);
alter table t1 add constraint primary key (c1) constraint t1_pk;

Then created the following replicate on the table:

cdr def repl -c g_er1 -C always -M g_er1 -S row er1_t1_rep "P
db1@g_er1:informix.t1" "select * from t1 where c2 in
(1,2,3,4,5)" "R db1@g_er2:informix.t1" "select * from t1 where
c2 in (1,2,3,4,5)"

cdr def repl -c g_er2 -C always -M g_er2 -S row er2_t1_rep "P
db1@g_er2:informix.t1" "select * from t1 where c2 in
(1,2,3,4,5)" "R db1@g_er1:informix.t1" "select * from t1 where
c2 in (1,2,3,4,5)"

Note, that c2 is a character column but the where clause in the
define replicate is using integer values because there are no
quotes around the numbers in the "in clause".

Then insert the following row on 1 side to get replicated.

insert into t1 values(4,"3");

Then do the following update statement:

update t1
set c2 = "a"
where c1 = 4;

When the update is processed by ER, it will shutdown ER with the
following error in the MSGPATH file:

11:00:33  Error - ER has encountered a fatal error and must shut
down
11:00:33  ER encountered a fatal error while evaluating
replicate er1_t1_rep
          SQLCODE:-1213 ISAMCODE:0

So at this point, ER is down and would need to do a cleanstart
to skip trying to process the update that changed the column
from a numeric value to a character value.

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Informix Server 12.10.xC14 or 14.10.xC4 (when      *
* available).                                                  *
****************************************************************

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Informix Server 12.10.xC14 or 14.10.xC4 (when      *
* available).                                                  *
****************************************************************

Fixed in Informix Server 12.10.xC14 and 14.10.xC4.

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

27.11.2019
28.02.2020
28.02.2020

12.10.xC14,
14.10.xC4