Bug #22648 LC_TIME_NAMES: Setting GLOBAL has no effect

Description:
When I set a GLOBAL variable, I expect that the setting
will take effect on other (new) connections. But with
LC_TIME_NAMES, there is no effect.

How to repeat:
On one connection, say:

SET GLOBAL LC_TIME_NAMES = 'ja_JP';

On another connection, started after the SET statement, say:

SELECT @@lc_time_names;
SELECT @@global.lc_time_names;
SELECT DAYNAME(CURRENT_DATE);

Thank you for the bug report. Verified as described.

mysqld should also support setting the global variable from
command line option at start up. Now it produces an error:

$./mysqld --lc_time_names=en_US
061122 12:48:38 [ERROR] ./mysqld: unknown variable 'lc_time_names=en_US'

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/23972

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/24051

Commited again, with a better command line help message.
Pushed into 5.0.40-rpl.

Pushed into 5.1.18-rpl

Pushed into 5.0.42

Pushed into 5.1.18-beta

Noted in 5.0.42, 5.1.18 changelogs.

Using SET GLOBAL to change the lc_time_names system variable had no
effect on new connections.