consistency check in MERGE with more data
-----------------------------------------
Key: CORE-4369
URL: http://tracker.firebirdsql.org/browse/CORE-4369
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 2
Environment: Firebird-3.0.0.30978-0_x64, Windows 7
Reporter: Alex Bekhtin
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 = 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).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
