H2 Blob Type support is incorrect
Description
Environment
All
Activity
Show:
Nathan Voxland December 5, 2013 at 3:02 PM
Fixed
Fixed
Details
Details
Reporter
Julien Baillagou
Julien BaillagouComponents
Fix versions
Affects versions
Priority
Created November 20, 2013 at 10:38 AM
Updated December 5, 2013 at 3:02 PM
Resolved December 5, 2013 at 3:02 PM
Hi,
A fix has been done for H2 for CLOB types (cf. https://liquibase.jira.com/browse/CORE-1288#icft=CORE-1288).
However, the fix has not been done for BLOB types.
Indeed, Liquibase converts "blob" into LONGVARBINARY type while H2 supports natively a BLOB type.
The consequence is : where our ORM tool expects a native 'BLOB', it fails because it finds a longvarbinary.
Liquibase should use the native type 'BLOB' (same as Oracle database in class "liquibase.datatype.core.BlobType")