Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2.2
-
None
-
Linux, Java 1.7
Description
Enabling the allowMultiQueries option in the JDBC URL to execute multiple queries in one statement in MySQL breaks batch inserts of more than one statement. This works in MySQL Connector/J. I'm not sure if this happens when connecting to real MariaDB, but my guess is yes.
It spews out a syntax error like this:
org.mariadb.jdbc.internal.common.QueryException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';insert into example.usage (`event_uuid`) values ('abc')' at line 1
|
A self contained example that reproduces the problem is located here: https://github.com/ProjectMoon/mariadb-batch-insert-bug