On following scenario:
create table "informix".table_a
(
id integer,
name char(10)
) WITH VERCOLS;
revoke all on "informix".table_a from "public" as "informix";
grant select on "informix".table_a to "public" as "informix";
grant update on "informix".table_a to "public" as "informix";
grant insert on "informix".table_a to "public" as "informix";
grant delete on "informix".table_a to "public" as "informix";
grant index on "informix".table_a to "public" as "informix";
If you run following sequences:
insert into table_a values (1, 'aaa');
select id, name, ifx_insert_checksum, ifx_row_version from
table_a;
begin work;
update table_a set name = 'bbb' where id = 1;
select id, name, ifx_insert_checksum, ifx_row_version from
table_a;
update table_a set name = 'ccc' where id = 1;
select id, name, ifx_insert_checksum, ifx_row_version from
table_a;
commit;
Result will be:
id name ifx_insert_checks+ ifx_row_version
1 aaa -190036525 1
id name ifx_insert_checks+ ifx_row_version
1 bbb -190036525 2
id name ifx_insert_checks+ ifx_row_version
1 ccc -190036525 3
If same sequence is run on HDR secondary (will fail with
-244/-7350)
id name ifx_insert_checks+ ifx_row_version
1 aaa -869941552 2
id name ifx_insert_checks+ ifx_row_version
1 bbb -869941552 4
244: Could not do a physical-order read to fetch next row.
7350: Attempt to update a stale version of a row |
****************************************************************
* USERS AFFECTED: *
* Users of IDS 14.10.xC1. *
****************************************************************
* PROBLEM DESCRIPTION: *
* ON AN UPDATABLE_SECONDARY, IF TABLE IS CREATED WITH VERCOLS, *
* IFX_ROW_VERSION IS INCORRECTLY UPDATED AND FAILS WITH *
* -244/-7350 *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
