I tried Liquibase 1.9.4 on our schema, here are my findings:
- Column CHAR(1) with DEFAULT ‘1’ was generated as '1 ’ which generated “value too large” error
- Strings with ’ in it generated errors because ’ was not masked
- FKs generated were wrong when there were two FK between the same tables
- Sequences were missing attributes: chachesize, minval, maxval, cycle
- Unique Indexes were generated as normal indexes
- Constraints that were non-validated became validated
- temporary tables became normal tables
- partitioned tables became normal tables
- tables were associated with other (default) tablespace
- check constraints other then not-null were missing
specially the problem with temporary and partitioned tables prevent us from using LiquiBase.
Regards, Ralph