Hey. I have a master changelog in XML format, where multiple changesets in raw SQL are included.
And yes, this is mandatory requirement.
So, when I try to setup rollback statement in those included files, the Liquibase does not see them.
This is the example of my changeset
– changeset creator.name:1 context:1.4.10-add_imagefilename_room
CREATE OR REPLACE VIEW MYSCHEMA.V_ROOM AS
SELECT
R.ID_ROOM AS ID_ROOM,
R.ID_FACILITY AS ID_FACILITY,
F.NAME AS FACILITY_NAME,
R.ID_ROOM_TYPE AS ID_ROOM_TYPE,
R.NAME AS NAME,
R.DESCRIPTION AS DESCRIPTION,
R.NUMBER AS NUMBER,
R.FLOOR AS FLOOR,
R.IMAGE_FILE_NAME AS IMAGE_FILE_NAME,
R.DISABLED AS DISABLED,
R.DISABLED_SINCE AS DISABLED_SINCE
FROM
(MYSCHEMA.ROOM R
JOIN MYSCHEMA.FACILITY F ON (((R.ID_FACILITY = F.ID_FACILITY)
AND (F.DISABLED = 0))));
– rollback DROP VIEW MYSCHEMA.V_ROOM;
And this is the result of using liquibase via maven plugin:
[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:4.11.0:rollback (default-cli) on project myproject-webportal:
[ERROR] Error setting up or running Liquibase:
[ERROR] liquibase.exception.RollbackFailedException: liquibase.exception.RollbackImpossibleException: No inverse to liquibase.change.core.RawSQLChange created