Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-71773

Add a unique constraint to the issuelinktype table

XMLWordPrintable

    • 0
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Problem Definition

      The Jira application does not allow to add duplicate values to the name of an issuelinktype  (linkname column) through the Jira user interface nor through the Jira REST API. However it is still possible to add duplicate issuelinktype.linkname values by performing direct SQL insert or update statements.

      It is important to note that having duplicate issuelinktype names (issuelinktype.linkname) can cause some operations such as exporting issues to CSV files to fail.

      Suggested Solution

      Please add a unique constrain on the linkname column of the issuelinktype table.


      Additional Comments

      • Please note that this suggestions aims to keep consistency with the approach already taken in the Jira aplication and enforced in the Jira user interface and REST API.
      • The described problem was found in Jira 8.5 and it is expected to be also present in previous Jira versions.

      issuelinktype table description:
       

               Table "public.issuelinktype"
  Column  |          Type          | Modifiers
----------+------------------------+-----------
 id       | numeric(18,0)          | not null
 linkname | character varying(255) |
 inward   | character varying(255) |
 outward  | character varying(255) |
 pstyle   | character varying(60)  |
Indexes:
    "pk_issuelinktype" PRIMARY KEY, btree (id)
    "linktypename" btree (linkname)
    "linktypestyle" btree (pstyle)

            [JRASERVER-71773] Add a unique constraint to the issuelinktype table

            There are no comments yet on this issue.

              Unassigned Unassigned
              ecasuscelli Esteban Casuscelli
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: