I’m using the default Liquibase configuration coming with Spring Boot. I have: a changelog.xml file in src/main/resources/db/changelog that works fine, along with url, changeLogFile, driver, username, password properties in application.properties, and a Maven pom.xml having this for <dependency> a…
Tag: liquibase
Create index with multiple columns
How can I create index with multile columns in liquibase yaml. I was trying to do something like that: But I am getting error column ‘name’ is required for all columns in an index. I saw similar questions, but answers/examples was written in xml and it was not working for me. Answer Above worked f…
How do I specify validchecksum to any in liquibase formatted sql?
I have run into an issue with liquibase. So , I made a mistake in my sql commands in one of the changesets. Now whenever I try to upgrade my deployment , the upgrade is failing due to wrong checksum. So I thought of doing the validCheckSum : ANY workaround and have run into this issue where it is not
how to convert this sql query to liquibase query
I have table like this I need to delete all duplicated rows with equals A nad B value and lower C value after running sql script i need to have only this row with top C Value for every equals A and B columns this is the sql query i am using how to convert it to liquibase query Answer
sql syntax error with liquibase using join tables
I am using liquibase, and I have a sql script: update edi_file_steps fs INNER JOIN GU_User u …
INSERT INTO table SELECT not working with constant values in H2 DB
Following is the H2DB query What I am trying to achieve is to insert a record into userpermission for user with given email address in user table, for each permission in permission table. Following is the error The same query is working in MySQL. Answer As mentioned in the comments, Use single quotes for stin…
Does Liquibase support dry run?
We have couple of data schemas and we investigate the migration to Liquibase. (One of data schemas is already migrated to Liquibase). Important question for us is if Liquibase supports dry run: We …