Bug #7298 Stored procedures: can't create procedure transaction
Submitted: 14 Dec 2004 20:37 Modified: 21 Apr 2005 12:18
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-alpha-debug OS:Linux (SUSE 9.2)
Assigned to: Bugs System CPU Architecture:Any

[14 Dec 2004 20:37] Peter Gulutzan 
Description:
The word TRANSACTION is not a reserved word. 
And it should not be a reserved word. 
But I can't create a procedure named "transaction". 
 

How to repeat:
mysql> create procedure transaction () set @x = @x; 
ERROR 1064 (42000): 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 'transaction () 
set @x = @x' at line 1
[14 Dec 2004 21:33] MySQL Verification Team 
Thank you for the bug report.
[21 Dec 2004 19:11] Peter Gulutzan 
I also cannot create procedures named "tables" or "privileges" or "columns" which were 
recently made non-reserved words, due to bug#7210.
[21 Apr 2005 12:18] Per-Erik Martin 
No longer repeatable.