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 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

Fixed

Details

Reporter

Components

Fix versions

Affects versions

Priority

Created April 3, 2013 at 9:17 AM
Updated October 28, 2013 at 9:50 AM
Resolved September 24, 2013 at 4:03 PM