Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-1281

Query for "get-by-field-value" is incorrect

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: OpenIDM 2.0.3, OpenIDM 2.1.0
    • Fix Version/s: OpenIDM 2.1.2, OpenIDM 3.0.0
    • Labels:
      None
    • Environment:
      CentOS 6.3 64bit, Java 1.7.0_11, MySQL 5.1.61-4.el6.x86_64

      Description

      Query for "get-by-field-value" in repo.jdbc.json returns result incorrectly with MySQL.
      Because plus is used for string concatenation as below.

      WHERE prop.propkey='/' + ${field}

      We correct it as the below. For string concatenation with MySQL, we must use CONCAT function.

      WHERE prop.propkey=CONCAT('/', ${field})

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                chad.kienle chad kienle
                Reporter:
                wadahiro Hiroyuki Wada
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: