MySQL Bugs: #20346: MySQL starts with event_scheduler=2 although my.ini sets it to 1

Bug #20346	MySQL starts with event_scheduler=2 although my.ini sets it to 1
Submitted:	8 Jun 2006 18:48	Modified:	10 Jun 2006 11:45
Reporter:	Markus Popp	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.11	OS:	Windows (Windows)
Assigned to:	Sveta Smirnova	CPU Architecture:	Any

Description:
I have set event-scheduler to 1 in my.ini, but after starting the server, event-scheduler is set to 2. This occurs in the Windows version only.

How to repeat:
Set my.ini to

[mysqld]
event-scheduler = 1

Restart the server.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.11-beta-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select @@event_scheduler;
+-------------------+
| @@event_scheduler |
+-------------------+
|                 2 |
+-------------------+
1 row in set (0.24 sec)

mysql> set @@global.event_scheduler := 1;

The server halts here.

Additional note: after killing the process from another client, event-scheduler was set to 1.

Maybe this is a bug on its own, but this doesn't work after having the event_scheduler value set to 1:

DROP TABLE tt;

CREATE TABLE  `tt` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `d` int(10) unsigned NOT NULL,
   `ts` timestamp NOT NULL,
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DELIMITER //

DROP EVENT insertIntoTT //

CREATE EVENT insertIntoTT
ON SCHEDULE EVERY 5 SECOND
STARTS current_timestamp + INTERVAL 5 SECOND
DO
BEGIN
  insert into tt (d) values (floor(rand() * 100));
END //

DELIMITER ;

Here's the output:

mysql> select * from tt;
Empty set (0.00 sec)

mysql> show events\G
*************************** 1. row ***************************
            Db: test
          Name: insertIntoTT
       Definer: mpopp@localhost
          Type: RECURRING
    Execute at: NULL
Interval value: 5
Interval field: SECOND
        Starts: 2006-06-08 18:51:06
          Ends: NULL
        Status: ENABLED
1 row in set (0.02 sec)

mysql> select * from tt;
Empty set (0.00 sec)

mysql> select @@event_scheduler;
+-------------------+
| @@event_scheduler |
+-------------------+
|                 1 |
+-------------------+
1 row in set (0.00 sec)

As said, it does not have problems on Linux

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

On my Windows XP SP2 it does not have problems too.