The CREATE TABLE doesn't fail only ALTER. And the release note confirm that weird behavior.
➤ mysql testing Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.7.17-0ubuntu0.16.04.1 (Ubuntu) .... mysql> create table foo (a DATETIME NOT NULL); Query OK, 0 rows affected (0.04 sec) This is unacceptable to won't fix this from my point of view because this use case is no longer possible: I want a NON-NULL datetime column and I want mysql REJECT my insert if that one is not set. If I'm forced to set a default, the default will be picked... and my request not rejected. So if I create a NEW database I can do this use-case. and if I have to upgrade an existing database I can't have this use case any more...awesome... Also my database have all DATETIME set, why mysql doesn't check that before refusing the ALTER, this is what serious sgbd does... -- 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
