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.

Sign up for GitHub

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

NOT NULL and DEFAULT do not work together with ALTER TABLE CHANGE COLUMN command #7455

Closed
GuptaManan100 opened this issue Feb 6, 2021 · 0 comments
Closed

NOT NULL and DEFAULT do not work together with ALTER TABLE CHANGE COLUMN command #7455

GuptaManan100 opened this issue Feb 6, 2021 · 0 comments
Assignees
@GuptaManan100
Labels
Component: Query Serving Type: Bug

Comments

@GuptaManan100
Copy link
Member

Initially the column part_number has no default value and can be null.

On running the query ALTER TABLE product115s CHANGE part_number part_number varchar(255) DEFAULT '0' NOT NULL
the default value is set correctly but the column is still nullable.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@GuptaManan100 GuptaManan100

Labels
Component: Query Serving Type: Bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@GuptaManan100