Altering domains name drops dependencies using the domain [CORE1986]

[firebird-automations]

Submitted by: DINC (dinc)

Is related to QA352

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.

Commits: 1442725

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA352 [ QA352 ]

[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