Hello to all,
I’m using liquibase (v2.0.1 and Informix DB) to generate differences from a referenced DB and my development one using the “diffChangeLog” command and redirecting the output to a XML file. I then used the “updateSQL” command based on this XML file to generate a SQL script that will bring my development DB to the same state as the reference one.
Examining the generated SQL script, I see that exists statements to correct some objects (like “CREATE INDEX xpto”, p.ex.) but then at the end of the script it drops the same objects (“DROP INDEX xpto”). I believe the drop statement should come before the create. This is getting me confused. Can someone please help me understand what is happening?