CSV Load Data inferes wrong column types when specify a single column mapping



We have some loadData calls using some CSV's. In version 3.4.2 everything works fine, but since version 3.6.X, generateStatements method in class LoadDataChange works slightly different.

If we have a database table with the following columns ID, NAME, CREATION_DATE and we have the following line (this is just an example)

Code reaches the following line:

In this example, columns is not empty, neither complete. So the only mapping is CREATION_DATE, trying to insert the ID field (number), as a string, and failing during the migration process

One solution could be completing mapping using default database mappings and giving a higher priority to the mappings defined in the file.

Due to this issue, we cannot upgrade liquibase dependencies to latest versions

Thanks a lot fot your help!


liquibase 3.4.2
csv loaddata


Bringer OfDawn

Affects versions