Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-3046

Liquibase uses wrong types in MySQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Must
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: OpenMRS 1.9.0
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Medium

      Description

      While looking at TRUNK-37, we realized that liquibase 2.0.1 has a dumb type mapping, where it maps CLOB to "text" in MySQL. (This is dumb, because a CLOB is supposed to be very large.)

      This is fixed in more recent versions of liquibase, to map to "longtext" (The latest is 2.0.3.) However in these later versions of liquibase, it seems that "text" also maps to "longtext". And all of our pre-1.9 liquibase changesets (which are mysql-specific) use "text" to mean the mysql type "text".

      We need to figure out how we can upgrade liquibase without having mysql users end up with excessively long text fields.

        Attachments

          Activity

            People

            Assignee:
            dkayiwa Daniel Kayiwa
            Reporter:
            darius Darius Jazayeri [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: