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

OFFSET missing from getSQLKeywords

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.3.3
    • 3.4.0
    • None
    • MariaDB Community Server 10.6

    Description

      After an update from MariaDB Server 10.4 to 10.11 my JVM program failed with the exception below (using Kotlin/Exposed).

      java.sql.BatchUpdateException: (conn=8994) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, `source`) VALUES ('LOCATIONS', '2024-04-02 08:42:05', '2024-04-02 08:...' at line 1
      SQL: [INSERT INTO source_parts (category, created, `last`, `limit`, list_completed, offset, `source`) VALUES (?, ?, ?, ?, ?, ?, ?)]

      JetBrains Exposed uses the DatabaseMetaData.getSQLKeywords() function to determine if a column name must be quoted, and 'offset' is not in the list returned by Connector/J, even though it has been added as a reserved word in MariaDB CS 10.6.0

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            jaapbeetstra Jaap Beetstra
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.