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: