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

Syntax error in HibernatePersonDAO search query

    XMLWordPrintable

    Details

    • Complexity:
      Low

      Description

      InĀ link HibernatePersonDAO

      Line # 177-178 read:

      q.append(" order by pname.givenName asc,").append(" pname.middleName asc,").append(" pname.familyName asc").append(" pname.familyName2 asc");

      There should be a comma at the end of "familyName asc" clause to avoid SQL Syntax error. Interestingly, this issue doesn't exist in master, I just saw it in 1.11x.

        Attachments

          Activity

            People

            Assignee:
            owais.hussain Owais Hussain [X] (Inactive)
            Reporter:
            owais.hussain Owais Hussain [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1 hour Original Estimate - 1 hour
                1h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours
                2h