Issue Details (XML | Word | Printable)

Key: CORE-3256
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0
Operations

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

Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan

Created: 25/Nov/10 08:54 AM   Updated: 04/Feb/11 01:21 PM
Component/s: Engine
Affects Version/s: 2.5.0
Fix Version/s: 2.5.1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
CREATE TABLE T1 (ID INTEGER NOT NULL,NAME INTEGER NOT NULL);
ALTER TABLE T1 ADD CONSTRAINT PK_T1 PRIMARY KEY (ID);
CREATE VIEW VT(ID,NAME) AS select * from t1;

-- repeat ~130 times
select * from vt where id=1 PLAN (vt T1 INDEX (PK_T1))
-- ERROR: request depth exceeded. (Recursive definition?)


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.