[CONJ-579] Keywords missing from DatabaseMetaData.getSQLKeywords() Created: 2018-02-08  Updated: 2018-02-20  Resolved: 2018-02-19

Status: Closed
Project: MariaDB Connector/J
Component/s: metadata
Affects Version/s: 2.2.0, 2.2.1
Fix Version/s: 2.2.2, 1.7.2

Type: Bug Priority: Minor
Reporter: Andreas Volkmann Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None
Environment:

Windows 10



 Description   

The DatabaseMetaData that is returned when calling getMetaData() on a Connection has a getSQLKeywords method.

According to it's documentation, it should return:

the list of this database's keywords that are not also SQL:2003 keywords

In my concrete example, I wanted to call a column index, but I got an exception because it is a reserved keyword. However, the keyword list returned by aforementioned method does not contain index.

I then took the list of keywords from here and the sql 2003 list from here and found over 100 missing keywords.

Am I missing something? Shouldn't these keywords be returned?

Here is the line in code, that should return the keywords: Link to MariaDB source

I have a repository recreating the issue on github



 Comments   
Comment by Diego Dupin [ 2018-02-19 ]

merge https://github.com/MariaDB/mariadb-connector-j/pull/122 (without the SQL:2003 keywords)

Generated at Thu Feb 08 03:16:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.