Bug #44483 Create a reserved keywords table
Submitted: 26 Apr 2009 18:29 Modified: 26 Apr 2009 19:08
Reporter: Senthil Nathan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[26 Apr 2009 18:29] Senthil Nathan 
Description:
It would be a good idea to have a table in the information_schema pre-populated with reserved keywords.  Oracle for example has one such table. Would make it quick and easy to check for reserved words without having to search the manual. I would rather search with a SQL in my database.

How to repeat:
n/a
[26 Apr 2009 19:08] Valeriy Kravchuk 
Thank you for the feature request.
[15 Nov 2013 10:54] Alexander Soklakov 
Posted by developer:
 
This also will help Connector/J to return actual values via DatabaseMetaData.getSQLKeywords() JDBC method. Now it's based on static manually maintained list which doesn't reflect changes between server versions and is updated irregularly.

The additional question here, is it possible to extend mysql.help_keyword table with a new field containing keyword tag reserved/not-reserved to avoid information_schema requests?