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

Liquibase uses wrong types in MySQL

    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.

        Gliffy Diagrams

          Attachments

            Attachments-Category-Modification

              Activity

                People

                • Assignee:
                  dkayiwa Daniel Kayiwa
                  Reporter:
                  darius Darius Jazayeri
                  Watchers:
                  Abbas Hachem, Ben Wolfe, Daniel Kayiwa, Darius Jazayeri, Saptarshi Purkayastha
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: