Driver version

12.8.1

SQL Server version

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)

Client Operating System

windows 10

JAVA/JVM version

java 17

Table schema

create table ygovil.VARCHAR_TABLE(
ID INT NOT NULL,
COL1 VARCHAR(10),
COL2 VARCHAR(10)
);

Problem description

Regression faced while uploading data from csv file to sql server table using SQLSERVERBULKCOPY. Earlier it was working. Its working fine until 12.6.4 version. Issue is that it loads one less record than the no of records present in the csv file. eg. lF we have 2 records in csv it loads only one record.
Also issue is happening when .setEscapeColumnDelimitersCSV(true) is set to true. its working otherwise, and previously was working with this option with older version.

Expected behavior

2 records should get loaded if 2 records are present in the csv

Actual behavior

1 record got loaded

Error message/stack trace

Run was successful

Any other details that can be helpful

NA

JDBC trace logs

NA