Uploaded image for project: 'ID Generation'
  1. ID Generation
  2. IDGEN-118

Convert tinyint(1) to boolean in liquibase file of IdGen Module

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Should
    • Resolution: Fixed
    • None
    • 4.6.0
    • None

    Description

      OpenMRS has equivalent boolean support that converts itself to tinyint(1) internally for MySQL. When starting reference metadata module you get an error with logs: https://pastebin.com/BHmcDSVf . It is due to the query :

      insert into idgen_auto_generation_option (uuid, identifier_type, location, source, manual_entry_enabled, automatic_generation_enabled, id) values ('47d1ba47-db31-4904-a140-cb9f4568f99c', 5, NULL, 1, 'FALSE', 'TRUE', 1)

      Liquibase converts tinyint to smallint for PostgreSQL which cannot store boolean True and False. We need to change tinyint(1) which is MySQL boolean equivalent to boolean for Idgen Module in its liquibase file.

      Gliffy Diagrams

        Attachments

          Issue Links

            Activity

              People

                aman Aman Mishra
                aman Aman Mishra
                Daniel Kayiwa Daniel Kayiwa
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved: