MySQL Bugs: #9694: Identifier escaping does not check sql

Bug #9694	Identifier escaping does not check sql_mode
Submitted:	6 Apr 2005 19:52	Modified:	4 Apr 2007 19:45
Reporter:	Dean Ellis	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	Connector / ODBC	Severity:	S4 (Feature request)
Version:	3.51.12	OS:	Any
Assigned to:	Jim Winstead	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The driver escapes with ` without checking server sql_mode, which may have ANSI_QUOTES enabled.

This is technically legal, but as Connector/J does perform the check and uses " when ANSI_QUOTES is enabled, it is inconsistent.

How to repeat:
Just examine the source.

Suggested fix:
Connectors behavior should be consistent where possible, so C/ODBC could perhaps also check the SQL mode and escape appropriately.

It is Connector/J that is being over-ambitious here. The backtick (`) is always a valid identifier quote, so we don't have to worry about the SQL_MODE being changed out from under us by always using them.