From: Dmitry Lenev Date: June 8 2011 9:11am Subject: Re: bzr commit into mysql-5.1 branch (Dmitry.Shulga:3662) Bug#57156 Bug#11764334 List-Archive: http://lists.mysql.com/commits/138906 Message-Id: <20110608091153.GA10829@bandersnatch> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Hello Dmitry! * Dmitry Shulga [11/06/08 10:52]: > #At file:///Users/shulga/projects/mysql/mysql-5.1-bug11764334/ based on revid:sergey.glukhov@stripped > > 3662 Dmitry Shulga 2011-06-08 > Fixed bug#11764334 (formerly bug#57156): ALTER EVENT CHANGES > THE EVENT STATUS. > > Any ALTER EVENT statement on a disabled event enabled it back > (unless this ALTER EVENT statement explicitly disabled the event). > > The problem was that during processing of an ALTER EVENT statement > value of status field was overwritten unconditionally even if new > value was not specified explicitly. As a consequence this field > was set to default value for status which corresponds to ENABLE. > > The solution is to check if status field was explicitly specified in > ALTER EVENT statement before assigning new value to status field. ... I think it is OK to push this patch after getting approval from the second reviewer. -- Dmitry Lenev, Software Developer Oracle Development SPB/MySQL, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification