ALTER DOMAIN <name> TO <newname> fails if there are dependencies [CORE6359]

[firebird-automations]

Submitted by: Wilfredo (wpomier)

I can understand when the ALTER DOMAIN fails because the type is being changed and there are dependencies.
But renaming the DOMAIN doesn't have any data integrity risk, am I wrong?
IMO It should be simply allowed.

[firebird-automations]

Commented by: @dyemanov

If a procedure declares local variable based on domain, how it should look after renaming the domain?

[firebird-automations]

Commented by: Wilfredo (wpomier)

I completely agree when there are dependencies in code (stored procedures, triggers, etc.), but when the dependencies affect only data e.g. a huge chain of constraints (pks, fks, uks) and indexes, it takes a lot of work just to rename a domain.