Bug #11110 Quoted Identifiers ending in space are not allowed
Submitted: 6 Jun 2005 9:37 Modified: 6 Jun 2005 10:02
Reporter: Mick Francis (Candidate Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:4.1.12a OS:NT
Assigned to: CPU Architecture:Any

[6 Jun 2005 9:37] Mick Francis 
Description:
An identifier, such as a table name, ending in a space (e.g. `T `) is not allowed. 

How to repeat:
CREATE TABLE `T ` (x int);
[6 Jun 2005 10:02] MySQL Verification Team 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

From the MySQl manual:

In addition to the restrictions noted in the table, no identifier can contain ASCII 0 or a byte with a value of 255. Database, table, and column names should not end with space characters. Before MySQL 4.1, identifier quote characters should not be used in identifiers.

http://dev.mysql.com/doc/mysql/en/legal-names.html
[6 Jun 2005 15:35] Mick Francis 
Fair enough - I'm sure I can live without spaces at the end of identifiers :)