Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: InterBase/Server/Internal    [ Add a report in this area ]  
Report #:  27513   Status: Closed
(Pulled) Too many foreign keys in a single script causes a "request depth exceeded" error.
Project:  InterBase Build #:  7.1.0.125
Version:    7.5 Submitted By:   John Kaster
Report Type:  Basic functionality failure Date Reported:  6/10/2003 12:00:00 AM
Severity:    Infrequently encountered problem Last Updated: 3/20/2012 2:24:39 AM
Platform:    Not OS or platform specific Internal Tracking #:   168847
Resolution: Fixed (Resolution Comments) Resolved in Build: : 7.5.1.162
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
Too many foreign keys in a single script causes a "request depth exceeded" error.
Steps to Reproduce:
Steps using IBConsole:

1) Create a new dialect 1 database.
2) Start an ISQL session.
Make sure AutoDDL is ON.
3) Load and execute the attached SQL script.

You'll get the following error:

---------------------------
Error
---------------------------
Error at line 8875 - unsuccessful metadata update
request depth exceeded. (Recursive definition?)

SQL - ALTER TABLE STORE
  ADD CONSTRAINT FK_STOREDEFAULT_SALE
  FOREIGN KEY (DEFAULT_SALES_ARTICLEID)
  REFERENCES ARTICLE
  /* Delete: SET NULL */
  ON DELETE SET NULL
  /* Update: NONE */
  /*ON UPDATE NO ACTION*/
---------------------------
Abort   Ignore  
---------------------------

The workaround is break apart the script, but this is very inconvenient when generating scripts with a tool like ERwin
Workarounds
None
Attachment
N
Comments

None

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.