MySQL Bugs: #23423: Syntax error for "ALTER EVENT ... COMMENT ..." on just two platforms

Bug #23423	Syntax error for "ALTER EVENT ... COMMENT ..." on just two platforms
Submitted:	18 Oct 2006 14:42	Modified:	13 Nov 2006 5:36
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S2 (Serious)
Version:	5.1.12-beta	OS:	Linux (Linux/S390 + OSX-PPC-64bit)
Assigned to:	Andrey Hristov	CPU Architecture:	Any

Description:
Found during release build of 5.1.12-beta:

=====
events                         [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line 60: query 'ALTER EVENT event_starts_test COMMENT "non-empty comment"' failed: 
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
=====

=====
events_grant                   [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line 84: query 'ALTER EVENT one_event COMMENT "comment"' failed:
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
=====

Occurred (for both of these) in *all* tests 
(debug, normal, ps, normal+rowrepl, ps+rowrepl+NDB)
just on two platforms:
etpglb0-5.1-community.log                   (Linux on S/390)
osx-tiger-ppc-64bit-5.1-community.log       (OS X 10.4, PPC, 64 bit)

How to repeat:
Run the test suite ...

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13985

ChangeSet@1.2329, 2006-10-19 15:56:37+02:00, andrey@example.com +1 -0
  Fix small glitch during parsing of ALTER EVENT xyz
  with only COMMENT clause. Strangely it has manifestated itself
  only on two platforms. This is a fix for bug#23423 
  "Syntax error for "ALTER EVENT ... COMMENT ..." on just two platforms"

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.1.12 changelog. Thanks, Andrey!