Issue Details (XML | Word | Printable)

Key: CORE-3060
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Nickolay Samofatov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

ALTER VIEW fails when updating two or more related views in one transaction

Created: 24/Jun/10 11:00 PM   Updated: 24/Jun/10 11:00 PM
Component/s: Engine
Affects Version/s: 2.5 RC2
Fix Version/s: None

Environment: Tested on Firebird 2.5.0.25782 (RC2)


 Description  « Hide
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


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no entries against this issue.