Issue Details (XML | Word | Printable)

Key: CORE-1907
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0
Operations

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

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

Created: 19/May/08 11:24 AM   Updated: 21/Apr/11 09:46 AM
Component/s: Engine
Affects Version/s: 2.5 Initial, 2.1.0
Fix Version/s: 2.5 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


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


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 21/Apr/11 09:46 AM
QA test added.