Bug #78065 5.7.8 startup warning about avoid_temporal_upgrade is not related to "syntax"
Submitted: 14 Aug 2015 6:51 Modified: 14 Aug 2015 6:59
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.7.8, 5.7.9 OS:Any
Assigned to: CPU Architecture:Any
Tags: avoid_temporal_upgrade

[14 Aug 2015 6:51] Simon Mudd
On starting 5.7.8 I notice in the error log:

2015-08-14T06:44:55.413107Z 0 [Warning] The syntax 'avoid_temporal_upgrade' is deprecated and will be removed in a future release

The message is fine but this has nothing to do with "syntax".

How to repeat:
Startup mysqld with /etc/my.cnf having avoid_temporal_upgrade = 1 configured. in the [mysqld] section.

Suggested fix:
Probably it's better to change "syntax" for "configuration option" or "configuration setting".
Yes, this is a minor thing but it stands out as being ugly. Fixing the message would be nice if possible.
[14 Aug 2015 6:59] MySQL Verification Team
Hello Simon,

Thank you for the report.

// with 5.7.9 build

[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.9-linux-x86_64: 2015-08-14T06:55:46.969705Z 0 [Warning] The syntax 'avoid_temporal_upgrade' is deprecated and will be removed in a future release

[19 Aug 2015 14:08] Ståle Deraas
Hi Simon,

We do acknowledge that this message is not "formally" correct. We are however
a bit reluctant to change this, since we feel that we also should change a
number of other messages as well if we were to change this.

There are several reasons for this reluctance:

1) We are using a general function to print all these deprecations messages,
and changing this strategy would mean we will add more code and risk of

2) Using this general function, makes the messages uniform in a way that they
are easily searchable in the error log. If we were to change this, some
people might be surprised when these messages do not turn up as results of
the search.