New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
DOMAINs don't register their dependency on other objects [CORE282] #613
Comments
Modified by: Alice F. Bird (firebirds)description: SFID: 1206386# Even if a domain has checks that depend on other SQL> create database 'depend.fdb'; No error message, the table is dropped. The domain SQL> create table u(a d); Generally, the posibility of having subselects in many => SFID: 1206386# Even if a domain has checks that depend on other SQL> create database 'depend.fdb'; No error message, the table is dropped. The domain SQL> create table u(a d); Generally, the posibility of having subselects in many |
Commented by: Claudio Valderrama C. (robocop) The problem has been fixed by Adriano's changes to enhance domain-related operations. This is the result of the same script: F:\fb2dev\fbbuild\firebird2\temp\debug\firebird\bin>isql Since the report is from May-2005 only today I remembered to recheck it. |
Modified by: Claudio Valderrama C. (robocop)status: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 RC1 [ 10201 ] assignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @pcisarWorkflow: jira [ 10306 ] => Firebird [ 14545 ] |
Commented by: @pmakowski Q/A test ok |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: Claudio Valderrama C. (robocop)
Block progress on CORE770
Is related to QA218
SFID: 1206386#
Submitted By: robocop
Even if a domain has checks that depend on other
objects, such dependency is not tracked. Contrived example:
SQL> create database 'depend.fdb';
SQL> create table t(a int);
SQL> create domain d int check(value > (select max(a)
from t));
SQL> drop table t;
No error message, the table is dropped. The domain
becomes unusable:
SQL> create table u(a d);
Statement failed, SQLCODE = -104
invalid request BLR at offset 16
-table id 128 is not defined
Generally, the posibility of having subselects in many
parts introduces dependencies that never have been
acknowledged.
The text was updated successfully, but these errors were encountered: