Commented by: @asfernandes

Also, DROP VIEW v_deps drops the shared domain.

Commented by: @asfernandes

This is 2.1:

SQL> create table t (n integer);
SQL> create view v as select * from t;
SQL> alter table t alter n type integer;
Statement failed, SQLCODE = -607
unsuccessful metadata update
-Column N from table T is referenced in V

Above commands seem to work in 2.1, but below ones doesn't, and the cause is the same:

SQL> create table t (n integer);
SQL> create domain d integer;
SQL> create view v as select * from t;
SQL> alter table t alter n type d;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-cannot delete
-DOMAIN RDB$3
-there are 1 dependencies

It may be possible (but not trivial) to fix what you reported in 2.5, but same thing using domains in parameters (as this last example) requires some redesign on how view fields works.

Commented by: @dyemanov

I'm afraid we have to fix it somehow, at least the originally reported issue. We offer a new feature (procedures inside views) but a requirement that prohibits any alteration of such procedures makes this feature very problematic to use.

Commented by: @asfernandes

I've did basic change to make the test case work in 2.5. In HEAD, the solution applied works with domains too.

Commented by: @pmakowski

Seems that the issue is not fixed in 3.0 branch
see :
http://web.firebirdsql.org/downloads/prerelease/results/3.0.0.31844/bugs.core_2923.html
http://ci.ibphoenix.fr/job/Firebird_3.0_Linux_64/Architecture=SuperServer/QA_Analysis_HTML_Report/bugs.core_2923.html
http://ci.ibphoenix.fr/job/Firebird_3.0_Linux_64/Architecture=Classic/QA_Analysis_HTML_Report/bugs.core_2923.html