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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.