Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.3.3
-
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