Rollback of the included SQL changeset does not work

General Discussion
1

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

2

Hi @sperchenko ,
Please confirm if all your changesets have rollback statements provided. As per Steve’s reply on this SO post it seems could be some issue with the changelog you are executing.

Thanks,
Rakhi Agrawal

3

Could you also provide details about the liquibase version you are using, this will help us to setup similar environment for reproducing the issue.

Thanks,
Rakhi Agrawal