Issue Details (XML | Word | Printable)

Key: CORE-6359
Type: Improvement Improvement
Status: Open Open
Priority: Trivial Trivial
Assignee: Unassigned
Reporter: Wilfredo
Votes: 0
Watchers: 5

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

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

Created: 08/Jul/20 01:02 AM   Updated: 09/Jul/20 12:20 AM
Component/s: Engine
Affects Version/s: 3.0.5
Fix Version/s: None

Environment: Linux 5.4.0-40-generic #44-Ubuntu SMP x86_64 GNU/Linux

QA Status: No test

 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 08/Jul/20 09:07 AM
If a procedure declares local variable based on domain, how it should look after renaming the domain?

Wilfredo added a comment - 09/Jul/20 12:20 AM
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.