"[Warning] TIMESTAMP with implicit DEFAULT value" on install
Bug #1516010 reported by
Robie Basak
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
mysql-5.6 (Ubuntu) |
Triaged
|
Low
|
Unassigned |
Bug Description
When installing mysql-server-5.6, the user gets the following warning printed to the terminal:
2014-05-14 13:54:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
This should not happen.
To post a comment you must log in.
The cause is that MySQL used to only support implicit timestamp default value, which is not according to the SQL spec. When this was fixed, it was decided to keep the old behavior for historical reasons, but add a deprecation warning.
Adding the suggested value to the config would remove the warning, but we'd be changing the default behavior of the server.