Bug #891 mysqldump and columns with question marks
Submitted: 22 Jul 2003 14:29 Modified: 22 Jul 2003 14:42
Reporter: Mauro Marcellino Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:4.0.13-nt OS:Microsoft Windows (Win 2K Server, Solaris 8)
Assigned to: CPU Architecture:Any

[22 Jul 2003 14:29] Mauro Marcellino
Description:
When I try to load a db from a dump that was created with mysqldump and there are question marks in column names (don't ask :)  ) I get the following error:

ERROR 1064 at line 3784: 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
'? text,
  PRIMARY KEY  (ID),
  UNIQUE KEY test (ID)
) TYPE=

Just wanted to bring it to your attention.  Thanks

How to repeat:
Use mysqldump to dump a database that has question marks (?) in the column names and then try to load from this dump file

Suggested fix:
It seems to not escape the "?" properly when the SQL syntax is created. I have used DBTools to dump the database and that seems to work fine.
[22 Jul 2003 14:42] 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

mysqldump willl quote table and column names if
you invoke it as mysqldump --quote-names
or mysqldump -Q.