Hello, I hope this is the right category for my question that has both SQLcl and CI/CD. I searched for the category but the SQLcl related category didn't seem like a good fit. So here it goes my question.
I'm trying to test the automation of database object changes via SQLcl and CI/CD pipeline. All went well until an attempt at rolling back the changes to a previous version. The simple test was rolling back a change made to a table where I added a column to it. But the rollback gave me the below error. From reading the oracle documentation on sqlcl, I thought this should work. I also read some article where it says the rollback needs to be manually written in the sql script. I was wondering if anyone has had similar experience or knows what to do with it. Thank you!!
SQL> lb rollback -tag 1.0 -changelog-file dist/releases/main.changelog.xml
--Starting Liquibase at 2026-05-07T14:31:14.587736 using Java 21.0.10 (version 4.33.0 #0 built at 2025-12-09 17:47+0000)
Rolling Back Changeset: feature/add-salary/ub_demo/views/v_employees_active.sql::1778177106019::USER_DEMO
ERROR: Exception Details
ERROR: Exception Primary Class: RollbackFailedException
ERROR: Exception Primary Reason: Liquibase does not support automatic rollback generation for raw sql changes (did you mean to specify keyword "empty" to ignore rolling back this change?)
ERROR: Exception Primary Source: 4.33.0
An error has occurred:
liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.RollbackFailedException: liquibase.exception.RollbackFailedException: Liquibase does not support automatic rollback generation for raw sql changes (did you mean to specify keyword "empty" to ignore rolling back this change?)