Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-579

Keywords missing from DatabaseMetaData.getSQLKeywords()

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.0, 2.2.1
    • Fix Version/s: 2.2.2, 1.7.2
    • Component/s: metadata
    • 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

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            avolkmann Andreas Volkmann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.