Skip to content

internal Firebird consistency check when trying to 'wrong' use computed_by index [CORE3763] #4107

Open
@firebird-automations

Description

@firebird-automations

Submitted by: @pavel-zotov

Is replaced by CORE3247

Votes: 1

on LI-V2.5.2.26308, also 2.5.2.26390

SQL> create database 't1.fdb'; commit;
SQL> create table t(id int); commit;
SQL> create index t_idx on t computed by( (select min(id) from t) ); -- this looks very 'strange', of course. But FB syntax allows such code!
SQL> commit;
SQL> insert into t values(123);
Aborted (core dumped)

on WI-V2.5.2.26390 the same actions results with:

Statement failed, SQLSTATE = 54001
unsuccessful metadata update
-request depth exceeded. (Recursive definition?)
-internal Firebird consistency check (error during savepoint backout (290), file: exe.cpp line: 4150)