We are inserting about 1200 rows in batches of 50 into a table called "Positionen" . The create table statement is inside createTable.txt , the query that fails is inside Query50.txt .
To reproduce, create a schema TESTDB and a table "Positionen" with the attached create statement. Then use the Code below to send the query through the ODBC Connector.
Inside the general query log two prepare statements are logged, but no execute is logged for the query from the file Query50.txt. The query does not return an exception. It returns 0 affected rows.
If we change the row batchsize to 49, 51, 100 or anything else, all 1200 rows are successful.
The file Query51.txt contains one extra row and is successful including all previous and subsequent batches on the table (does include the rows from Query50.txt).
The insert batch size of 50 rows does work for MariaDB 10.1.31.
Both queries are successful, if you use mysqlclient on MariaDB 10.2.13 .
Does the syntax check fail without notice during the prepare on 10.2.13 for the query in the file Query50.txt?