Bug #81010 | ALTER TABLE DROP DEFAULT - default value of NULL not forced | ||
---|---|---|---|
Submitted: | 8 Apr 2016 10:34 | Modified: | 11 Apr 2016 13:18 |
Reporter: | Power Gamer | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
Version: | 5.7.11, 5.6.29, 8.0.17 | OS: | Windows |
Assigned to: | CPU Architecture: | Any | |
Tags: | DROP DEFAULT, null |
[8 Apr 2016 10:34]
Power Gamer
[8 Apr 2016 11:01]
Power Gamer
In "How to repeat" section a comment for ALTER TABLE should read: # Contradicts Quote 2 - default value of NULL for column "a" is not forced during ALTER TABLE. ALTER TABLE ttt ALTER a DROP DEFAULT;
[11 Apr 2016 13:18]
MySQL Verification Team
Hello! Thank you for the report and test case. Observed this with 5.6.29/5.7.11. Thanks, Umesh
[11 Apr 2016 13:19]
MySQL Verification Team
Related Bug #80222
[14 Oct 2019 10:09]
MySQL Verification Team
Bug #97212 marked as duplicate of this one