firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Regression. RECREATE VIEW fails with "View ... does not exist" after b/r on 6.0.0.673-7519f25

Open pavel-zotov opened this issue 9 months ago • 0 comments

Following was checked on WI-T6.0.0.673 Firebird 6.0 7519f25:

Step-1: run script:

set bail on;
set echo on;
shell del c:\temp\tmp4test.fdb 2>nul;
create database 'localhost:c:\temp\tmp4test.fdb' user 'sysdba' password 'masterkey';
recreate view v_data as select 1 x from rdb$database;
commit;

Step-2: make b/r %FB_HOME%\gbak -b localhost:c:\temp\tmp4test.fdb stdout | %FB_HOME%\gbak -rep stdin localhost:c:\temp\tmp4test.restored.fdb

Step-3: run script which tries to recreate view on just restored DB

set bail on;
set echo on;
connect 'localhost:c:\temp\tmp4test.restored.fdb' user 'sysdba' password 'masterkey';
recreate view v_data as select 1 x from rdb$database;

Ouput will be:

connect 'localhost:c:\temp\tmp4test.restored.fdb' user 'sysdba' password 'masterkey';
show version;
ISQL Version: WI-T6.0.0.673 Firebird 6.0 7519f25
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T6.0.0.673 Firebird 6.0 7519f25"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T6.0.0.673 Firebird 6.0 7519f25/tcp (PZ)/P20:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T6.0.0.673 Firebird 6.0 7519f25/tcp (PZ)/P20:C"
on disk structure version 14.0
recreate view v_data as select 1 x from rdb$database;
Statement failed, SQLSTATE = 42S02
unsuccessful metadata update
-RECREATE VIEW V_DATA failed
-SQL error code = -607
-Invalid command
-View V_DATA does not exist

No such problem on 6.0.0.673-0-40f5be4 (many previous snapshots alsa were checked).

pavel-zotov avatar Mar 14 '25 22:03 pavel-zotov