Bug #31946 the reserved word X509 can be used as procedure name.
Submitted: 30 Oct 2007 12:10 Modified: 12 Nov 2007 8:58
Reporter: Horst Hunger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Parser Severity:S3 (Non-critical)
Version:5.1.23-beta, 5.0 BK OS:Linux (Suse 10.2)
Assigned to: CPU Architecture:Any

[30 Oct 2007 12:10] Horst Hunger 
Description:
The test "myisam_storedproc.test" succeeded in line 1778 'CREATE PROCEDURE x509()...' though  itn should fail with error 1064.

How to repeat:
use "x509" as procedure name.
[30 Oct 2007 12:27] Horst Hunger 
This is also valid for the following case:
CREATE PROCEDURE sp1()
  x509:BEGIN
    SELECT @x;
END//
[30 Oct 2007 15:50] Sveta Smirnova 
Thank you for the report.

Verified as described.
[31 Oct 2007 19:45] Sergei Golubchik 
Why should it fail ?
[31 Oct 2007 20:05] Paul DuBois 
Horst, are you expecting failure because X509 is listed as a reserved word in the manual? It turns out that there was a bug in my script that identifies these words, and X509 drops out of the list when the bug is fixed. (Serg identified the problem.)
[12 Nov 2007 8:58] Sveta Smirnova 
Thank you for the feedback.

User manual has been fixed and 'x509' was removed from the list of reserved words.