Bug #74849 default_password_lifetime is volatile, doesn't need to be - protected by mutex

Description:
default_password_lifetime is a global variable in mysqld.cc, and indeed a server global variable.

The idea is that when this value is updated, new passwords will have a lifetime of X days.

Since system variables are protected by LOCK_global_system_variables, we have all the appropriate protections for updating default_password_lifetime. The addition of volatile just makes the compiler unable to do some optimization for no good reason.

In reality, this probably isn't much of an issue and the assembler produced is likely correct, but volatile should throw up a red flag everywhere it's used, and if LOCK_global_system_variables suddenly went away, then this code would very subtly become incorrect, with people likely thinking that 'volatile' protects it in ways that it doesn't.

How to repeat:
code analysis.

Suggested fix:
apply my patch! (attached)

remove volatile from default_password_lifetime

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: volatile-default_password_lifetime.patch (text/x-patch), 1.12 KiB.

Hello Stewart,

Thank you for the report and contribution.

Thanks,
Umesh

Noted in 5.7.6 changelog.

default_password_lifetime was marked volatile, unnecessarily because
it is protected with a mutex. Thanks to Stewart Smith for the patch.