firebird
firebird copied to clipboard
Regression. RECREATE VIEW fails with "View ... does not exist" after b/r on 6.0.0.673-7519f25
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).