Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
pavel-zotov opened this issue Mar 14, 2025 · 0 comments

Comments

@pavel-zotov
Copy link

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).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant