ALTER VIEW opens a can of worms for (invalid) recursive views
-------------------------------------------------------------
Key: CORE-2734
URL:
http://tracker.firebirdsql.org/browse/CORE-2734 Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Reporter: Claudio Valderrama C.
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.
http://p.sf.net/sfu/bobj-julyFirebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
