Bug #529 "x509" no allowed as field name --> give specific error message
Submitted: 28 May 2003 22:11 Modified: 29 May 2003 2:59
Reporter: Ralf Hauser Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:4.0.12-max-nt for NT on i32 OS:Microsoft Windows (win2k)
Assigned to: Sergei Glukhov CPU Architecture:Any

[28 May 2003 22:11] Ralf Hauser
With version 3.2* we had a field "x509" in our schema and all worked fine.

How to repeat:
When trying to load the same schema.sql in my current version, I got the quite unspecific <<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 'x509 CHAR(255) NULL, logo_url CHAR(255) NULL, last_login DATETI>>

Suggested fix:
1) allow me to use arbitrary field names again
2) if not, provide a specific error message with a unique number that points me to a "man page" URL describing this limitation or a "reserved words" list
[29 May 2003 2:59] Sergei Glukhov
Added possibility of using 'x509' column name