Unnecessary size specifications on MEDIUMTEXT, TINYTEXT, MEDIUMBLOB, TINYBLOB from generateChangeLog

Description

TO REPRODUCE

  1. In your MySQL database, use

  1. to create a test table

  2. Use Liquibase 3.0.2 or 3.0.1 to run generateChangeLog against that database preserving the resulting changeLog in a file

  3. Try to use the generated change log to re-create the table in another schema

EXPECTED RESULTS

The table should be replicated to the new schema

ACTUAL RESULTS

SQL Errors. After some trial and error this was traced back to size specification on the following data types.

  • MEDIUMTEXT

  • TINYTEXT

  • MEDIUMBLOB

  • TINYBLOB

After removing the sizes associated with the types mentioned above, Liquibase ran without errors and created the table. I have attached the original output

and the modified and working changelog

Environment

MySQL 5.1 on CentOS 6.3
MySQL 5.5 on Windows 7

Reporter

Peter Pickerill

Fix versions

Affects versions

Priority

Major
Configure