load[Update]Data treats values differently depending column type is defined

Description

Values are treated differently whether the column type is defined. If the type is retrieved from the DB or defined in the change, then the inserted value:

column type

literal "null"

space around values

defined

DB NULL value

full value

not defined

““ (empty string)

trimmed value

The error is in liquibase.change.core.LoadDataChange.getValueToWrite() different from generateStatements

Environment

Windows, JDK 8

Reporter

Gyula Bibernáth

Affects versions

Priority

Minor
Configure