MySQL Bugs: #78065: 5.7.8 startup warning about avoid_temporal

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:	None
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

Description:
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.

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

Thanks,
Umesh

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
problems.

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.

/Staale