Issue Details (XML | Word | Printable)

Key: CORE-4812
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Jiri Cincura
Votes: 0
Watchers: 5
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Gbak cannot restore database with cyclic dependencies between views

Created: 26/May/15 06:39 AM   Updated: 27/May/15 10:38 AM
Component/s: Engine, GBAK
Affects Version/s: 2.5.4
Fix Version/s: None

Environment: Windows x64, Firebird x64


 Description  « Hide
Steps to reproduce:
*** 1:
CREATE OR ALTER VIEW CYCLE_A(
    COL)
AS
select RDB$RELATION_ID from rdb$database
;
*** 2:
CREATE OR ALTER VIEW CYCLE_B(
    COL)
AS
select RDB$RELATION_ID from rdb$database
;
*** 3:
CREATE OR ALTER VIEW CYCLE_A(
    COL)
AS
select RDB$RELATION_ID from rdb$database
union all
select col from cycle_b
;
*** 4:
CREATE OR ALTER VIEW CYCLE_B(
    COL)
AS
select RDB$RELATION_ID from rdb$database
union all
select col from cycle_a
;
*** 5: Backup database using gbak.
*** 6: Try restoring database using gbak. Fails with depth limit failure.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.