|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
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?)
|
|
Description
|
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?)
|
Show » |
| There are no comments yet on this issue.
|
|
Bug
Closed
Major
Error "request depth exceeded" may appear while preparing a select query against a view with explicit plan