Can't make validCheckSum overwrite work in formatted sql file

General Discussion
1

I have a formatted sql file that I change a little and want to adjust the validchecksum so it isn’t reapply in my database :slight_smile:

--liquibase formatted sql

--changeset me:mytable
--validCheckSum: 9:cfc4244ce5b371e468ce6e9d2822b442
CREATE TABLE ....

but everytime I get the exception :

[2025-03-09 20:06:16] INFO [liquibase.ui] ERROR: Exception Primary Class:  ValidationFailedException
ERROR: Exception Primary Reason: Validation Failed:
     1 changesets check sum
          .../....sql::...::me was: 9:cfc4244ce5b371e468ce6e9d2822b442 but is now: 9:049e47f7a1acd7054d5dcd548d6b16d9

The file is an formatted sql file, included in the main liquibase-changelog.xml by a
<include file=“…/myfile.sql” … />

I am using Liquibase Version: 4.26.0

2

seems upgrading to liquibase 4.31.1 fix the problem

1 Like