Database Migration Plugin

Error specifying a length for a blob column

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major 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.

Activity

Hide
Permalink
James Kleeh added a comment -

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.

Show
James Kleeh added a comment - 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.

People

  • Assignee:
    Burt Beckwith
    Reporter:
    Seth Fuller
Vote (2)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved: