I’m sure some people must have run into this problem before…
I’m installing the same schema to DB2 and HSQL, then doing a diff between them and I’m getting differences such as:
from VARBINARY(1048576) to BLOB
from VARCHAR(1048576) to CLOB
The reason is because in HSQL, Liquibase is calls BLOBs & CLOBs – VARBINARY & VARCHAR.
I tried modifying the Liquibase Diff code to say if the type is “VARCHAR” just call it a CLOB instead, and it fixed it for HSQL / DB2 diffing, but then when I diff other DBs like HSQL / MySQL I get the error again because they call it yet another name. I found that depending on the DB, a CLOB could be called: TEXT, LONG VARCHAR, LONGVARCHAR, or BLOB SUB_TYPE TEXT
Obviously the hack that I wrote isn’t a very good solution; so I’m wondering how other people are handling these type name mismatches?