You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: