We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Submitted by: @samofatov
ALTER VIEW fails when updating several interrelated views in one transaction.
---- test.sql set autoddl off;
create table test_table ( id integer );
create view test_view(t) as select id from test_table;
create view test2_view(t2) as select t from test_view;
commit;
alter view test2_view(t2) as select cast(null as integer) from rdb$database;
alter view test_view(t) as select cast(null as integer) from rdb$database;
alter view test2_view(t2) as select t from test_view;
alter view test_view(t) as select id from test_table;
Statement failed, SQLCODE = 42000 unsuccessful metadata update -cannot delete -DOMAIN RDB$5 -there are 1 dependencies
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Submitted by: @samofatov
ALTER VIEW fails when updating several interrelated views in one transaction.
---- test.sql
set autoddl off;
create table test_table (
id integer
);
create view test_view(t) as
select id from test_table;
create view test2_view(t2) as
select t from test_view;
commit;
alter view test2_view(t2) as
select cast(null as integer) from rdb$database;
alter view test_view(t)
as select cast(null as integer) from rdb$database;
commit;
alter view test2_view(t2) as
select t from test_view;
alter view test_view(t) as
select id from test_table;
commit;
Statement failed, SQLCODE = 42000
unsuccessful metadata update
-cannot delete
-DOMAIN RDB$5
-there are 1 dependencies
The text was updated successfully, but these errors were encountered: