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

Convert Global Property column to varchar

    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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Attachments-Category-Modification

                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: