loadData fails to insert data when usePreparedStatements=true

[neupsh]

Environment

Liquibase Version: 4.2.0 (also reproducible in 4.1.1)

Liquibase Integration & Version: spring boot, but is reproducible by cli (see below)

Liquibase Extension(s) & Version:

Database Vendor & Version: postgres:10.7

Operating System Type & Version:

Description

loadData change type fails to insert data when usePreparedStatements=true. The update operation completes without any error.

Steps To Reproduce

I have tried to simplify the steps to reproduce using cli instead of spring boot integration.

• Database Setup (if not already available)
  Execute the following to run a temporary postgres docker:

docker run -it -e POSTGRES_PASSWORD=password postgres:10.7-alpine

• A csv file to load data from: app_user.csv with the following content:

"id","name"
"1","John"
"2","Doe"

• A changelog.xml with the following changesets:

    <changeSet id="1-createTable" author="neupsh">
      <createTable tableName="app_user">
          <column name="id" type="int"/>
          <column name="name" type="varchar(255)"/>
      </createTable>
    </changeSet>

    <changeSet id="2-loadData" author="neupsh">

        <loadData commentLineStartsWith="#" encoding="UTF-8" file="app_user.csv" quotchar="&quot;" relativeToChangelogFile="true" separator="," tableName="app_user" usePreparedStatements="true">
            <column header="id" name="id" type="NUMERIC"/>
            <column header="name" name="name" type="STRING"/>
        </loadData>
    </changeSet>

• correct liquibase.properties pointing to the postgres db listed above
• run liquibase update

Actual Behavior

• Liquibase update is successful
• app_user table is created
• app_user table is empty
• databasechangelog table has both changesets executed

Expected/Desired Behavior

• Liquibase update is successful
• app_user table is created
• app_user table is populated with the contents from csv file
• databasechangelog table has both changesets executed

If I change the usePreparedStatements="true" to usePreparedStatements="false" in the loadData changesets, the data is populated correctly.
I have attached the sample project to reproduce. Please modify the drivers location to execute it.
postgres.zip

[tomjo]

We have also encountered this issue with Liquibase version 3.10.3 which was pulled in by Spring Boot since Spring Boot version 2.4.1.

[vmarcinko]

We also experienced the same with Liquibase 4.7.1 and MySQL and mysql-connector-java JDBC driver 8.0.25. Everything works well when usePreparedStatements="false"

[kflorian]

Can still confirm this issue with MariaDB 10.7.1 and liquibase version 4.8.0.

[aaron-splicer]

ditto for similar mariadb and liquibase v. 4.9.0

[heneke]

The cause of this issue is described here: a50e90b

[FBurguer]

Look like it got fixed for liquibase 4.16.1. Im closing this issue, but if the issue continues to happen to you, please reopen the issue and let us know. Thanks!