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
• Status: Closed
• 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

Description:
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