Bug #91435 Improve DatabaseMetaData.getSQLKeywords() to include new reserved words
Submitted: 27 Jun 2018 11:32 Modified: 11 Jul 2019 19:57
Reporter: Yanming Zhou (OCA) Email Updates:
Status: Closed Impact on me:
Category:Connector / J Severity:S3 (Non-critical)
Version:8.0.11 (5.1.47) OS:Any
Assigned to: CPU Architecture:Any

[27 Jun 2018 11:32] Yanming Zhou
Mysql 8.0 add a lots of new reserved words. https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-new-8-0-A

Driver should add them if DatabaseMetaData.getDatabaseMajorVersion() equals 8.

How to repeat:
[29 Jun 2018 9:36] Chiranjeevi Battula
Hello zhou yanming,

Thank you for the bug report.
Verified based on internal discussion with dev's.

[27 Sep 2018 13:59] Alexander Soklakov
The issue was fixed in c/J 8.0.12 under WL#10544 "Update MySQL 8.0 keywords list". But it's still present in c/J 5.1 driver. So changing the affected version to 5.1.47.
[11 Jul 2019 19:57] Daniel So
Posted by developer:
Added the following entry to the Connector/J 5.1.48 changelog:

"The list of MySQL Server reserved words, stored as the MYSQL_KEYWORDS string in the DatabaseMetaData class, has been updated."