A new topic, 'liquibase status updates the checksum in DATABASECHANGELOG', has
been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=109.new#new
The text of the topic is shown below:
When using the runOnChange="true" tag in a change set for a view such as the
following:
<changeSet author="abernaps" id="22" runOnChange="true">
<sqlFile splitStatements="true" stripComments="false"
path="database/changelogs/r1.0/V_Client_Demographic.sql" />
</changeSet>
If you change the V_Client_Demographic.sql file then run a liquibase update
command it would normally rerun this change set and that is the desired result.
However if you run liquibase status first, then liquibase update the change is
ignored because the liquibase status command is updating the checksum in the
DATABASECHANGELOG.
This is easiest to see this behavior is to run liquibase status twice in a row
after making the change to this type of change set. You will see the first
status say "1 change sets have not been applied", then the next status command
will report "0 change sets have not been applied".
I used sql profiler to verify the update statement is being sent to the
database on a status call.
UPDATE [DATABASECHANGELOG] SET [MD5SUM] = 'e962e83d2befa13db12794b756d2bc2'
WHERE ID = '3' AND AUTHOR = 'abernaps' AND FILENAME =
'database/ChangeLogs/r1.0/sprint2.changes.xml'
Take care,
Pat
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
