description: CREATE TABLE T1 (
ID INTEGER,
VAL INTEGER
);

CREATE TABLE T2 (
ID INTEGER,
VAL INTEGER
);

execute block as
begin
delete from t1;
delete from t2;
insert into t1 (id, val)
select row_number() over(), 10000000 from rdb$types rows 100;
insert into t2
select * from t1;
end

merge into t2 as trg
using (select * from t1) as src
on 1=1 --trg.id = http://src.id
when matched then update set trg.val = src.val

-----------------------
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
internal Firebird consistency check (applied differences will not fit in record (177), file: sqz.cpp line: 147).

=>

CREATE TABLE T1 (
ID INTEGER,
VAL INTEGER
);

CREATE TABLE T2 (
ID INTEGER,
VAL INTEGER
);

execute block as
begin
delete from t1;
delete from t2;
insert into t1 (id, val)
select row_number() over(), 10000000 from rdb$types rows 100;
insert into t2
select * from t1;
end

commit;

merge into t2 as trg
using (select * from t1) as src
on 1=1 --trg.id = http://src.id
when matched then update set trg.val = src.val

-----------------------
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
internal Firebird consistency check (applied differences will not fit in record (177), file: sqz.cpp line: 147).

Regression: 3.0 Alpha 2 [ 10560 ]

assignee: Vlad Khorsun [ hvlad ]

assignee: Vlad Khorsun [ hvlad ] => Dmitry Yemanov [ dimitr ]

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 2 [ 10586 ]

summary: consistency check in MERGE with more data => BUGCHECK for MERGE with multiple matches

summary: BUGCHECK for MERGE with multiple matches => BUGCHECK(177) for MERGE with multiple matches

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

QA Status: Done successfully

Test Details: Confirmed result in WI-T3.0.0.31374 Beta-1: message in firebird.log
"internal Firebird consistency check (applied differences will not fit in record (177), file: sqz.cpp line: 147)"

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