Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: Grails-Database-Migration 1.3
-
Labels:None
-
Environment:Grails 1.3.7, MySql 5.5, OSX 10.7
Description
When I run dbm-gorm-diff I get the following statement:
changeSet(author: "sethfuller (generated)", id: "1317218434408-1") { modifyDataType(columnName: "file_data", newDataType: "longblob(5000000)", tableName: "document") }
This tries to set a size for the longblob type. When I run dbm-update for this statement I get an exception:
ERROR liquibase - Change Set unneeded2.groovy::1317218434408-1::sethfuller (generated) failed. Error: Type class liquibase.database.structure.type.BlobType doesn't support precision but precision was specified liquibase.exception.UnexpectedLiquibaseException: Type class liquibase.database.structure.type.BlobType doesn't support precision but precision was specified
This looks like it may be a problem with Liquibase generating a difference when it (or the database) doesn't support specifying a length for a blob type, but I thought I'd report the error anyway.
I should add that the migrations plugin attempts to use CLOB(255) in Oracle, where of course that is invalid. I just ignore the change when I run dbm-gorm-diff.