[CONJ-1109] Regression in clearBatch() for parameterized statements Created: 2023-09-11  Updated: 2023-11-24  Resolved: 2023-11-24

Status: Closed
Project: MariaDB Connector/J
Component/s: batch
Affects Version/s: 3.0.3, 3.2.0
Fix Version/s: 3.3.1

Type: Bug Priority: Major
Reporter: MichaƂ Wójtowicz Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None

Attachments: Java Source File MariaDBCommitRollback.java    

 Description   

3.2.0 MariaDB Connector/J (the same noticed with 3.0.3) shows regression in using clearBatch() for parameterized statements. This worked fine in 2.7.2. I'm attaching Java app to reproduce and results using both versions.

//

{4, XB4} missing - correct
Driver version: 2.7
Driver name: MariaDB Connector/J
Driver version name: 2.7.2
Database product name: MariaDB
Database product version name: 10.5.5-MariaDB
Database product version number: 10.5
JDBC version number: 4.2

Table created
Commit the batch
Roll back
Commit the batch
===========
1, XB1
2, XB2
3, XB3
5, XB5
===========
Table dropped

// {4, XB4}

present - incorrect
Driver version: 3.2
Driver name: MariaDB Connector/J
Driver version name: 3.2.0
Database product name: MariaDB
Database product version name: 10.5.5-MariaDB
Database product version number: 10.5
JDBC version number: 4.2

Table created
Commit the batch
Roll back
Commit the batch
===========
1, XB1
2, XB2
3, XB3
4, XB4
5, XB5
===========
Table dropped


Generated at Thu Feb 08 03:20:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.