If I have following seed file:
--liquibase formatted sql
--changeset Deepak Aggarwal:20260301231321_insert_seeds_country
-- Description: asdasd
-- SQL goes here
INSERT INTO country (countryId) values ('some_countryId');
--rollback -- truncate country;
The above query successfully deploys and rollbacks too using rollbackCount 1.
However, if I use variables as
INSERT INTO country (countryId) values (‘${countryId}’);
and update it as
liquibase \
update \
-DcountryId=some_country_id
It sucessfully updates and I also see my passed value. But on rollback it gives checksum error. I tried multiple times. direct values work fine. but the moment I have parameter value, rollback stops working.
How can this be resolved?
thanks