Bug #95985 SET GLOBAL on rbr_exec_mode fails
Submitted: 25 Jun 2019 21:42 Modified: 25 Jun 2019 22:29
Reporter: Manuel Rigger Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.7/8.0 OS:Ubuntu
Assigned to: CPU Architecture:x86

[25 Jun 2019 21:42] Manuel Rigger
According to the documentation, rbr_exec_mode has Global and Session scope (see https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_rbr_exec_mode). However, SET GLOBAL on this variable fails.

How to repeat:
SET GLOBAL rbr_exec_mode = STRICT; -- unexpected: ERROR 1228 (HY000): Variable 'rbr_exec_mode' is a SESSION variable and can't be used with SET GLOBAL
SET SESSION rbr_exec_mode = STRICT; -- no error
[25 Jun 2019 22:29] MySQL Verification Team
Thank you for the bug report. Maybe a documentation bug.