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

Jump to bottom

Add DROP NOT NULL to ALTER COLUMN [CORE4466] #4786

Closed
firebird-automations opened this issue Jun 20, 2014 · 3 comments
Closed

Add DROP NOT NULL to ALTER COLUMN [CORE4466] #4786

firebird-automations opened this issue Jun 20, 2014 · 3 comments
Labels
component: engine fix-version: 3.0 Alpha 1 priority: minor qa: done successfully type: new feature

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Maximiliano Robaina (maxirobaina)

Add DROP NOT NULL statement to remove NOT NULL field definition.

i.e.: ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;

====== Test Details ======

Test does NOT verifies work when table has some data. It only checks ability to issue DDL statement
@firebird-automations
Copy link
Collaborator Author

Commented by: @sim1984

It is already implemented in Firebird 3
ALTER DOMAIN my_domain {NULL | NOT NULL}
ALTER TABLE my_table ALTER my_column {NULL | NOT NULL}

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

Test Details: Test does NOT verifies work when table has some data. It only checks ability to issue DDL statement

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
component: engine fix-version: 3.0 Alpha 1 priority: minor qa: done successfully type: new feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations