Bug #2024 illegal characters (-+) not noted in documentation

• Submitted: 5 Dec 2003 9:50
• Modified: 5 Dec 2003 9:57
• Reporter: Michael Winston
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 4.0.16
• OS: MacOS (mac os x 10.x)
• CPU Architecture: Any

[5 Dec 2003 9:50] Michael Winston

Description:
http://www.mysql.com/doc/en/Legal_names.html
lists a few illegal characters for table names but leaves out mathematical operators such as '+' and 
'-'.

I discovered this when a fellow developer backed-up a table to 'test-11-16-2003' in phpMyAdmin 
(which, or course, quotes all table names).

How to repeat:
select * from test+5;
ERROR 1064: 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 '+5' at line 1

[5 Dec 2003 9:57] Paul DuBois

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

You can use those characters in table names, as long
as you quote the name with backticks. The characters
listed as illegal are illegal even in quoted names.