This was actually a bug in 5.7.16: >From the 5.7.17 changelog: "An in-place ALTER TABLE operation failed to report >an error when adding a DATE or DATETIME column under these conditions: a) the >column was NOT NULL and no default value was supplied; b) strict and >NO_ZERO_DATE SQL modes were enabled; c) the table was not empty."
Basically, for this to work, you should supply a valid non-zero default date to the alter statement. Or, if you want zero-dates, remove NO_ZERO_DATE from the sql_mode variable in your server. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1657989 Title: No more able to create non null datetime column To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1657989/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
