Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Fixed
- 
    3.1.2
- 
    None
- 
    win10pro[64bit], 10.5.4-MariaDB, java8
Description
regression.
2.7.x connector works, 3.x.y connector fails to execute nonparameterized batch of statements in multiquery mode [in connection url: allowMultiQueries=true]
 "SET @name := '123'; INSERT INTO products( name ) VALUES ( @name )".
OUTPUT when fails with connector driver ver. 3.1.2:
|  running: | 
|   SELECT version() as serverVersion | 
|  Server version: [{serverVersion=10.5.4-MariaDB}] | 
|  Driver version: 3.1.2 | 
|  running: | 
|   DROP TABLE IF EXISTS products | 
|  running: | 
|   CREATE TABLE IF NOT EXISTS products ( | 
|     id       int unsigned AUTO_INCREMENT NOT NULL, | 
|     name     varchar( 100 ) NOT NULL, | 
|     created  datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, | 
|     PRIMARY KEY ( id ) | 
|   ) DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci | 
|  running batch: | 
|   SET @name := '123'; | 
|   INSERT INTO products( name ) VALUES ( @name ) | 
| [ WARN] (main) Error: 1064-42000: 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 'INSERT INTO products( name ) VALUES ( @name )' at line 2 | 
| [ WARN] (main) Error: 1243-HY000: Unknown prepared statement handler (4294967295) given to mysqld_stmt_execute | 
| Exception in thread "main" java.sql.BatchUpdateException: (conn=1341) 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 'INSERT INTO products( name ) VALUES ( @name )' at line 2 | 
| 	at org.mariadb.jdbc.export.ExceptionFactory.createBatchUpdate(ExceptionFactory.java:181) | 
| 	at org.mariadb.jdbc.ClientPreparedStatement.executeBatchBulk(ClientPreparedStatement.java:179) | 
| 	at org.mariadb.jdbc.ClientPreparedStatement.executeInternalPreparedBatch(ClientPreparedStatement.java:115) | 
| 	at org.mariadb.jdbc.ClientPreparedStatement.executeBatch(ClientPreparedStatement.java:466) | 
| 	at test.MariaDB_Regression2.runBatch(MariaDB_Regression2.java:87) | 
| 	at test.MariaDB_Regression2.main(MariaDB_Regression2.java:107) | 
| Caused by: java.sql.BatchUpdateException: (conn=1341) 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 'INSERT INTO products( name ) VALUES ( @name )' at line 2 | 
| 	at org.mariadb.jdbc.export.ExceptionFactory.createBatchUpdate(ExceptionFactory.java:215) | 
| 	at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:620) | 
| 	at org.mariadb.jdbc.ClientPreparedStatement.executeBatchBulk(ClientPreparedStatement.java:148) | 
| 	... 4 more | 
| Caused by: java.sql.SQLSyntaxErrorException: (conn=1341) 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 'INSERT INTO products( name ) VALUES ( @name )' at line 2 | 
| 	at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:282) | 
| 	at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:370) | 
| 	at org.mariadb.jdbc.message.client.PreparePacket.readPacket(PreparePacket.java:74) | 
| 	at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:855) | 
| 	at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:794) | 
| 	at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:713) | 
| 	at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:571) | 
| 	... 5 more
 |