Issue Details (XML | Word | Printable)

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

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

Few problems with domains's check constraints

Created: 02/Aug/07 04:49 AM   Updated: 08/Dec/08 09:04 AM
Component/s: None
Affects Version/s: 2.1 Beta 1
Fix Version/s: 2.1 Beta 2

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
Here is a script for making all necessary objects:

CREATE TABLE TEST ( ID INTEGER );
CREATE DOMAIN TEST_DOMAIN AS INTEGER CHECK (EXISTS(SELECT * FROM TEST WHERE ID=VALUE));

Now there are 3 problems:
1) Server didn't create any dependency
2) I can drop table TEST without any problems (think because of 1): DROP TABLE TEST;
3) After table was dropped i can make backup and restore without any problems. I think server should show some message at the end of beckup or restore log...


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 08/Dec/08 09:04 AM
Q/A test ok