Bug #90939 ERROR 1238 (HY000): Variable 'explicit_defaults_for_timestamp' is a read only va

• Submitted: 19 May 2018 3:43
• Modified: 21 May 2018 6:04
• Reporter: kfpanda kf
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.6.39, 5.6.40
• OS: Any
• CPU Architecture: Any

[19 May 2018 3:43] kfpanda kf

Description:

https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defau...

In the document, parameter explicit_defaults_for_timestamp is a dynamic parameter, but it is not.

How to repeat:

mysql> set global explicit_defaults_for_timestamp=on;
ERROR 1238 (HY000): Variable 'explicit_defaults_for_timestamp' is a read only variable
mysql>
mysql>
mysql>
mysql>
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.6.39    |
+-----------+
1 row in set (0.00 sec)

Suggested fix:
According to the instructions in the 5.6 document, it is adjusted to dynamic parameters.

In the 5.7 version of the document, the parameter a is a dynamic parameter, and the actual test is also a dynamic parameter.

[21 May 2018 6:04] MySQL Verification Team

Hello!

Thank you for the report.

Thanks,
Umesh