Skip to content
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

Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL [CORE3085] #3464

Closed
firebird-automations opened this issue Jul 28, 2010 · 10 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Is duplicated by CORE1684

The following clause will be useful in case of need to change domain NULL-values tolerance:

ALTER DOMAIN my_domain SET NULL VALUES ENABLE | DISABLE

- with the mandatory checking of EXISTING data against new (offered by developer) rule for null values.

Commits: 6479022 36f092f FirebirdSQL/fbt-repository@47a6da0

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

summary: add clause ALTER DOMAIN <my_domain> SET [NOT] NULL => add clause ALTER DOMAIN <my_domain> SET NULL VALUES ENABLE | DISABLE

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Following the same feature added for tables in v3.0, I'd suggest it looking like:

ALTER DOMAIN my_domain {NULL | NOT NULL}

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

summary: add clause ALTER DOMAIN <my_domain> SET NULL VALUES ENABLE | DISABLE => Add clause ALTER DOMAIN <name> [NOT] NULL

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Ain Valtin (ain)

Looks like this is dublicate for CORE1684 (which too can now be marked as fixed).

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Link: This issue is duplicated by CORE1684 [ CORE1684 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

summary: Add clause ALTER DOMAIN <name> [NOT] NULL => Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants