H2 (and other) support for BLOB and CLOB is incorrect
Description
Environment
None
Activity
Show:
Julien Baillagou October 28, 2013 at 9:50 AM
Hi,
CLOB support has been corrected but BLOB type wasn't.
Indeed, Liquibase converts "blob" into LONGVARBINARY type while H2 supports natively a BLOB type.
cf. liquibase class "liquibase.datatype.core.BlobType"
Can you provide a fix for this problem as well ?
Best regards,
Julien
Damien Biggs April 4, 2013 at 2:56 PM
I have a pull request open for this.
https://github.com/liquibase/liquibase/pull/100
java.sql.Blob and Clob have been with us for many years now, yet Liquibase is mapping these incorrectly for H2.
Specifically, the H2TypeConverter is incorrectly overridding the correct defaults.
For Liquibase 3.0, I think it would be wise to clean up lots of this code and support modern versions of these database drivers.
The following code needs deleting: