Bug #16401 Events: mysql.event.comment is varchar(64)
Submitted: 12 Jan 2006 3:42 Modified: 2 Feb 2006 4:48
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.1.6-alpha-debug OS:Linux (SUSE 10.0)
Assigned to: Andrey Hristov CPU Architecture:Any

[12 Jan 2006 3:42] Peter Gulutzan 
Description:
The mysql_fix_privilege_tables.sql "CREATE EVENT" statement
creates a table which has a column `comment` varchar(64).
This is inconsistent with mysql.proc, which has
`comment` char(64).

How to repeat:
less mysql_fix_privilege_tables.sql
[23 Jan 2006 21:12] 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/1522
[26 Jan 2006 19:32] 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/1688
[26 Jan 2006 22:05] 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/1699
[26 Jan 2006 22:11] Andrey Hristov 
Fixed in 5.1.6
fixed files:
scripts/mysql_fix_privilege_tables.sql
scripts/mysql_create_system_tables.sh
mysql-test/lib/init_db.sql (part of the test suite)
[2 Feb 2006 4:48] Mike Hillyer 
Documented in 5.1.6 changelog:

<listitem>
        <para>
          <literal>mysql.event.comment</literal> column changed from VARCHAR(64) to
          CHAR(64) in system table creation scripts. (Bug #16401)
        </para>
      </listitem>