H2 (and other) support for BLOB and CLOB is incorrect

Description

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:

Environment

None

Activity

Show:
Julien Baillagou
October 28, 2013, 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

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Reporter

Neale