Issue Details (XML | Word | Printable)

Key: CORE-6135
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: ABog
Votes: 0
Watchers: 2
Operations

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

An error occurred while trying to change the service (non-user) domain if there are interrelated views

Created: 03/Sep/19 08:02 PM   Updated: 04/Sep/19 06:01 AM
Component/s: None
Affects Version/s: 3.0.4
Fix Version/s: None

Environment: 3.0.5.33151

QA Status: No test


 Description  « Hide
create table SOME$TABLE (SOME$FIELD integer);
create view SOME$VIEW1(SOME$FIELD) as select T.SOME$FIELD from SOME$TABLE T;
create view SOME$VIEW2(SOME$FIELD) as select T.SOME$FIELD from SOME$VIEW1 T;

create domain D$SOME$DOMAIN as integer;
alter table SOME$TABLE alter column SOME$FIELD type D$SOME$DOMAIN;

This operation is not defined for system tables.
unsuccessful metadata update.
cannot delete.
DOMAIN RDB$XXXXX.
there are 1 dependencies.

The problem is the presence of a second view. If you remove it or remove a variable field from it, there will be no error.
Moreover, if the domain of the field (for example, initially when creating the table) is set to custom, then changing it to another is quiet.


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Attila Molnár added a comment - 04/Sep/19 06:01 AM
Looks like CORE-4844.