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

database meta getSQLKeywords listing all reserved key word, not retricted keywords only

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.4.0
    • 3.4.1
    • metadata
    • None

    Description

      from https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/Unexpected.20Keywords.20in.20MariaDB.20Connector.2FJ.203.2E4.2E0

      After CONJ-1170, DatabaseMetadata.getSQLKeywords() list all MariaDB keywords (minus SQL2003 reserved keywords).

      SQL distinguishes between reserved and non-reserved key words. According to the standard, reserved key words are the only real key words; they are never allowed as identifiers. Non-reserved key words only have a special meaning in particular contexts and can be used as identifiers in other contexts.

      The use of DatabaseMetadata.getSQLKeywords() is for frameworks to identify reserved words force quoting for example.

      DatabaseMetadata.getSQLKeywords() must only list reserved key words, not reserved and non-reserved key word

      Attachments

        Activity

          People

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