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

Avoid using MySQL reserved word "rank" as Column Name

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Must
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Core 2.5.0
    • Component/s: None
    • Labels:

      Description

      rank is an SQL reserved word since MySQL 8.0.2: but we are using it as a field name in the Diagnosis class.

      Causes the below SQL error while trying to create a Visit Note via the OWA/UI;

      Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank) values ('09aafee4-c8a1-4f17-a185-c9e2cda72363', null, 1, null, '2021-10-31' at line 1
      

       See discussion on this here.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                miirochristopher Christopher Miiro
                Reporter:
                miirochristopher Christopher Miiro
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: