2 -> 3.1 migration, 3.1 errors if there are single quotes in comments

Description

If you have a single quote in a comment, if errors when trying to insert into the DATABASECHANGELOG. This corrupts the change log!

[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.1.0:update (default-cli) on project service-web: Error setting up or running Liquibase: Error executing SQL INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, LIQUIBASE) VALUES ('1', 'xxx xxx', 'src/main/resources/database/changesets/xxx/21-xxx-xxx-ticket-price-set-10p.xml', CURRENT TIMESTAMP, 1815, '7:127c7b34560a12f31d840bed27579318', 'update (x5)', '5p xxx xxx' to '10p xxx xxx', 'EXECUTED', '3.1.0'): An unexpected token "to" was found following "5)', '5p Game BOGOF'". Expected tokens may include: ",".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.52.95 -> [Help 1]

XML:

<comment>'5p Game 10 GBP' to '10p Game 10 GBP' </comment>

Workaround: change single quote into double quote and add <validCheckSum/>.

Environment

OS-X/DB2

Status

Assignee

Unassigned

Reporter

AlexC

Labels

None

Components

Fix versions

Affects versions

3.1.0

Priority

Major