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

[18 Oct 2006 14:42] Joerg Bruehe
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 ...
[19 Oct 2006 13:58] Bugs System
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"
[13 Nov 2006 5:36] Jon Stephens
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!