Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ALTER VIEW opens a can of worms for (invalid) recursive views [CORE2734] #3129

Open
firebird-automations opened this issue Nov 6, 2009 · 1 comment

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Claudio Valderrama C. (robocop)

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 3.0 Initial [ 10301 ]

Version: 2.5 Beta 2 [ 10300 ]

Version: 3.0 Alpha 1 [ 10331 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant