Hi!
I localized the commit who caused this bug, but so far I'm unable to
fix. It's this one:
Date: Mon Feb 28 10:11:37 2011 +0000
Additional patch for CORE-3362 : Cursors should ignore changes made
by the same statement
AFAIU, the commit is not a problem per se, but exposed something already
problematic. But I may be wrong.
Adriano
On 21/03/2014 11:13, Alex Bekhtin (JIRA) wrote:
> 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).
>
>
>
>
>
------------------------------------------------------------------------------
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/NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
