Deleting a custom field fails with "No operator matches the given name and argument type" when JIRA is connected to Postgres

XMLWordPrintable

    • 7.02
    • 1
    • Severity 2 - Major
    • 0

      Summary

      Customers using Postgres 10.13 trying to remove custom fields encounter an error:

      Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, ISSUE, CUSTOMFIELD, UPDATED, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE FROM public.customfieldvalue WHERE CUSTOMFIELD=? (ERROR: operator does not exist: character varying = bigint
      Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
      Position: 156)

      The same problem is partially fixed by JRASERVER-20554. This one was never discovered.

              Assignee:
              Unassigned
              Reporter:
              Henrique Bittencourt (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: