Dealing with changing changesets within a release cycle

General Discussion
1

Team,

I was interested in how most teams handle schema changes which are really fixes for earlier changesets e.g. updating the correct field value which is changed a few times within a release i.e. before any customer would ever test. e.g. consider

  1. UPDATE CONFIGPARAMS SET VALUE=‘MYVALUE1’

  2. UPDATE CONFIGPARAMS SET VALUE='MYVALUE2

  3. UPDATE CONFIGPARAMS SET VALUE=‘MYVALUE3’’

Suppose by changeset 3 this was the GA candidate. When we generated our SQL to deploy to the customer we wouldn’t really want three update statements when only the last was intended.

This page provides some options

http://www.liquibase.org/2008/10/dealing-with-changing-changesets.html

However the most appropriate solution I can see this page lists is

"List checksums which are considered valid for this changeSet, regardless of what is stored in the database. Used primarily when you need to change a changeSet and don’t want errors thrown on databases on which it has already run (not a recommended procedure). Since 1.7

What is cleanest way to handle this here? What are others currently doing?

Many thanks

Matt