MySQL Bugs: #22408: Events: can't set global event

Bug #22408	Events: can't set global event_scheduler = 2
Submitted:	15 Sep 2006 21:11	Modified:	25 Sep 2006 18:08
Reporter:	Peter Gulutzan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1.12-beta-debug	OS:	Any (all)
Assigned to:	Jon Stephens	CPU Architecture:	Any

Description:
The MySQL Reference Manual, Section 20.1. Event Scheduler Overview, says:
"The global variable event_scheduler ... can have one of these 3 values
... 2: The Event Scheduler is SUSPENDED ..."
But I can't set the event scheduler to 2.

How to repeat:
mysql> set global event_scheduler = 0;
Query OK, 0 rows affected (0.01 sec)

mysql> set global event_scheduler = 1;
Query OK, 0 rows affected (0.01 sec)

mysql> set global event_scheduler = 2;
ERROR 1231 (42000): Variable 'event_scheduler' can't be set to the value of '2'

Thank you for a bug report. Verified just as described with latest 5.1.12-BK on Linux.

Jon Stephens has been notified of this change. The typelib has been changed.

--event-scheduler= DISABLED | ON | OFF | ) | 1  ( 0 = OFF, 1 = ON)
variable event_scheduler= 0 | 1 | OFF | ON

Changing this to documentation bug.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Updated Event Scheduler and DB Administration chapters of 5.1 Manual with new 5.1.12 behaviour.

See also Bug #22662.