Issue Details (XML | Word | Printable)

Key: CORE-2734
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Claudio Valderrama C.
Votes: 0
Watchers: 0
Operations

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

ALTER VIEW opens a can of worms for (invalid) recursive views

Created: 06/Nov/09 01:39 PM   Updated: 06/Nov/09 02:47 PM
Component/s: Engine
Affects Version/s: 2.5 Beta 2, 3.0 Initial
Fix Version/s: None


 Description  « Hide
F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'view.fdb';
SQL> create table t(a int);
SQL> create view v1 as select a from t;
SQL> create view v2 as select a from v1;

So far so good, we have v2 -> v1 -> t, but...

SQL> alter view v1 as select a from v2;
SQL> commit;
SQL> select * from v1;
Statement failed, SQLSTATE = 54001
Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255


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