Bug #25525 SAVEPOINTS identifiers require a non-numeric character
Submitted: 10 Jan 2007 16:29 Modified: 11 Jan 2007 14:53
Reporter: Lindsay Snider Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0.26 OS:Linux (linux)
Assigned to: Paul DuBois CPU Architecture:Any
Tags: rollback, savepoint, savepoints, transactions

[10 Jan 2007 16:29] Lindsay Snider
Description:
On mysql 5.0.26 in an innodb table, the savepoint command will fail if a non-numeric character is not used in the identifier.

How to repeat:
START TRANSACTION;
INSERT INTO TEST VALUES(1, 'test');
SAVEPOINT 10;    #FAILS
SAVEPOINT 10a;   #WORKS

Suggested fix:
If this is by design, maybe add documentation to http://dev.mysql.com/doc/refman/5.0/en/savepoints.html suggesting so.
[11 Jan 2007 13:55] Stefan Hinz
In the Language Structure chapter, Identifiers section (e.g. http://dev.mysql.com/doc/refman/5.1/en/identifiers.html), we're indeed not saying that an identifier may contain numbers but may not consist only of numbers. We should add that information, possibly to the list of restrictions given in that section.
[11 Jan 2007 14:53] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Adding this to legal-identifiers section:

Identifiers may begin with a digit but unless quoted may not
consist solely of digits.

This will appear at:
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html