Hello all,
Any inputs on the below?
Multi line/block rollback not working when there is “GO” in the statement: (Version: 4.19)
/* liquibase rollback
USE DATABASE_TEST
GO
DROP VIEW Customer_view;
*/
Error: incorrect syntax near “GODROP”
Hello all,
Any inputs on the below?
Multi line/block rollback not working when there is “GO” in the statement: (Version: 4.19)
/* liquibase rollback
USE DATABASE_TEST
GO
DROP VIEW Customer_view;
*/
Error: incorrect syntax near “GODROP”
I think from the “USE DATABASE_TEST” that this is SQL-Server, which I don’t really know.
But I think this error has to do with GO not being recognized as a statement delimiter within this rollback block. Can you remove the GO and use a semicolon delimiter?
removing it works, but there are scenarios where we have to use GO. Like -
USE DATABASE_TEST
GO
Was just wondering if there was a way to make it work.