update or insert with gen_id() with wrong generator value [CORE2041]

[firebird-automations]

Submitted by: Hans Englhauser (englhauser)

Relate to CORE2584
Is related to QA359

I think this runs wrong:

CREATE GENERATOR LOGID;
set generator LOGID to 0;
CREATE TABLE LOGBOOK
( ID integer not null,
TS timestamp,
ENTRY varchar(64),
PRIMARY KEY (ID));

update or insert into logbook (id, ts, entry) values (gen_id(LOGID, 1), 'now','Testing 1');
update or insert into logbook (id, ts, entry) values (gen_id(LOGID, 1), 'now','Testing 2');
update or insert into logbook (id, ts, entry) values (gen_id(LOGID, 1), 'now','Testing 3');
update or insert into logbook (id, ts, entry) values (gen_id(LOGID, 1), 'now','Testing 4');
select * from logbook;

/* ID in table LOGBOOK is not incremented by 1, but by 3.
Workaround is possible with stored procedure: */

set term ^ ;
create procedure logrow(txt varchar(64)) as
declare variable lid integer;
begin
lid = gen_id(LOGID, 1);
update or insert into logbook (id, ts, entry)
values (:lid, 'now',:txt);
end^
set term ; ^

execute procedure logrow('Test 1');
execute procedure logrow('Test 2');
execute procedure logrow('Test 3');
execute procedure logrow('Test 4');
select * from logbook;

Commits: 9150e6f 5d4084d

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

[firebird-automations]

Modified by: @asfernandes

Link: This issue relate to CORE2584 [ CORE2584 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA359 [ QA359 ]

[firebird-automations]

Commented by: @pcisar

QA test added.

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully