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

Keywords missing from DatabaseMetaData.getSQLKeywords()

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.2.0, 2.2.1
    • 2.2.2, 1.7.2
    • metadata
    • None
    • 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

            diego dupin Diego Dupin
            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.