Informix and additivity

Liquibase has several refactorings that result in MODIFY clause that gets constructed.

Any other thoughts?

Best,
Laird

The other possibility which is more general in nature is to add an attribute to the addNotNullConstraint change.

L

My first suggestion won’t work, I don’t think, because when Liquibase is being run in updateSQL is to ask the database itself for as little as humanly possible.

Best,
Laird

Yes, the idea of updateSQL is that you can’t really ask the database for anything because it isn’t going to be in the state you think that it is.


It isn’t just informix that has auto-committing alter table statements, most are like that.  I don’t know of any way round the problem other than trying to do what is possible to ensure that once the first alter commits, no others will fail because otherwise liquibase gets into an odd state.  It’s a database limitation I’m not sure how to work around.


Nathan

Well–and I’m not thinking very clearly this morning–I don’t oldType is the data type of the column).

L