Dropping and adding a domain constraint in the same transaction leaves incorrect dependencies [CORE1907]

[firebird-automations]

Submitted by: @asfernandes

Is related to QA346

Teste case:

create database 't.fdb';

create table t1 (n integer);
create table t2 (n integer);

create domain d1 integer check (value = (select n from t1));
commit;

set autoddl off;

alter domain d1 drop constraint;
alter domain d1 add constraint check (value = (select n from t2));;
commit;

drop table t1; -- cannot drop - there are dependencies
commit;

Commits: b471e91

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA346 [ QA346 ]

[firebird-automations]

Commented by: @pcisar

QA test added.

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully