MySQL Bugs: #95985: SET GLOBAL on rbr_exec

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:	None
Category:	MySQL Server: Options	Severity:	S3 (Non-critical)
Version:	5.7/8.0	OS:	Ubuntu
Assigned to:		CPU Architecture:	x86

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

Thank you for the bug report. Maybe a documentation bug.