Gbak cannot restore database with cyclic dependencies between views
-------------------------------------------------------------------
Key: CORE-4812
URL: http://tracker.firebirdsql.org/browse/CORE-4812
Project: Firebird Core
Issue Type: Bug
Components: Engine, GBAK
Affects Versions: 2.5.4
Environment: Windows x64, Firebird x64
Reporter: Jiri Cincura
Priority: Critical
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
