Issue Details (XML | Word | Printable)

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

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

Altering domains name drops dependencies using the domain

Created: 10/Jul/08 04:06 AM   Updated: 25/Apr/11 02:38 PM
Component/s: Engine
Affects Version/s: 2.1.0
Fix Version/s: 2.5 Beta 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
For example, we have a database:
CREATE DOMAIN D_SOME AS INTEGER;

CREATE OR ALTER PROCEDURE SP_SOME(
    SOME_PARAM D_SOME)
AS
BEGIN
END;

So if we try to change domains name by:
ALTER DOMAIN D_SOME TO D_OTHER;

Then the first execute/commit gives (bugs origin?):
Cannot commit transaction:
table is not defined.
domain D_SOME is not defined.

But the second execute/call succeeds.
After that we have no domain dependency for procedure SP_SOME, also error if try to execute procedure.

Also we can alter domain to its original name - no dependency, but no errors for execute procedure.


 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 - 25/Apr/11 02:38 PM
QA test added.