Re: [Firebird-devel] Replication - generators' value are not replicated

[Dmitry Yemanov]

18.05.2021 14:36, Omacht András wrote:

Ok, let's see the following example:
Master:
CREATE SEQUENCE TMP_GEN_2;
commit;

CREATE TABLE TMP_TABLE (
     VC  VARCHAR(10)
);
commit;

CREATE OR ALTER TRIGGER TMP_TABLE_BIU0 FOR TMP_TABLE
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
as
declare variable dummy integer;
begin
   dummy = gen_id(tmp_gen_2, 1);
end
commit;

insert into TMP_TABLE (VC) values ('A');
commit;
-- At this point in master and replica's generator has the same value: 1

update tmp_table set vc = 'B';
commit;
-- At this point master's generator value is 2, but the replica's generator 
value is 1.

What you should get is a "Table TMP_TABLE has no unique key" error while 
committing the UPDATE statement.


Dmitry


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel