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

Add null constraint for issuenum column to jiraissue table

    XMLWordPrintable

Details

    • 2
    • 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.

    Description

      Problem Definition

      In some cases due to JSWSERVER-16473 Jira ends up with a NULL value in the issuenum column of jiraissue table,

      Current schema:

                        Table "public.jiraissue"
              Column        |           Type           | Modifiers
      ----------------------+--------------------------+-----------
       id                   | numeric(18,0)            | not null
       pkey                 | character varying(255)   |
       issuenum             | numeric(18,0)            |
       project              | numeric(18,0)            |
      ...
      Indexes:
          "pk_jiraissue" PRIMARY KEY, btree (id)
          "issue_assignee" btree (assignee)
          "issue_created" btree (created)
          "issue_duedate" btree (duedate)
          "issue_proj_num" btree (issuenum, project)
          "issue_proj_status" btree (project, issuestatus)
          "issue_reporter" btree (reporter)
          "issue_resolutiondate" btree (resolutiondate)
          "issue_updated" btree (updated)
          "issue_votes" btree (votes)
          "issue_watches" btree (watches)
          "issue_workflow" btree (workflow_id)
      

      Suggested Solution

      Prevent the data consistency problem by adding not null constraint for issuenum column for jiraissue table.

      Workaround

      None

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ayakovlev@atlassian.com Andriy Yakovlev [Atlassian]
              Votes:
              13 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated: