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

Convert Global Property column to varchar

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Should
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: OpenMRS 1.9.0, 1.9 Beta Sprint
    • Component/s: None
    • Labels:
      None
    • Complexity:
      Low

      Description

      In TRUNK-94 the global_property.property column was changed from a varchar to varbinary in order to support case sensitive searching.

      This brought about some undesirable effects:

      1. varbinary is mysql specific
      2. varbinary columns show up strangely/inconveniently in db editors
      3. keys like "restModule" and "restmodule" are treated differently, even though they should be the same.

      Convert this column back to a varchar. Make sure all inserts/updates/fetches on the column treat the column as case insensitive. (I believe the original reason for the ticket was that inserts were case sensitive but fetches were not)

      DO NOT change the case of keys as they are being entered. We want the case to be preserved.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sunbiz Saptarshi Purkayastha
              Reporter:
              bwolfe Ben Wolfe
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: