> I want a NON-NULL datetime column and I want mysql REJECT my insert if
that one is not set.
That's fine. But since you're adding a column, all existing rows need a
value for your new column. If you're saying these values must not be
NULL, then what value are these existing rows supposed to get?
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);
s/sgbd/RDBMS/
--
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/u
Thank you for taking the time to report this bug and helping to make
Ubuntu better.
We aim for no user-visible changes in updates to the stable release, and
Oracle aim for this in their updates too, consulting with us about
proposed changes that may change user behaviour first. In this case, it
lo
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 en
** Tags added: regression-update
** Changed in: mysql-5.7 (Ubuntu)
Importance: Undecided => High
--
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 date
