Issue Summary

Some pull requests and branches are not showing in development panel.

This is reproducible on Data Center: yes 

Steps to Reproduce

Environment requirement:

1. required: MSSQL server database (couldn't reproduce e.g. on Postgres)
2. diagnosed on Jira 9.2 - but probably all versions below 9.7 are impacted
3. diagnosed with using GitLab self managed 15.9 but probably earlier versions and git provider leads to same result

Create git repository

1. Recreate git structure:
   
2. Open merge requests (in order):

• "DoS-1 - D2_to_d1" from branch DOS-2-branch into DOS-1-branch
• "DOS-1 d1_to_main" from branch DOS-1-branch into main
• "DOS-2 d2_to_main" from branch DOS-2-branch into main

Prepare project in jira

1. Create project in Jira with issue key DOS
2. Create "First issue"
3. Create "Second issue"

   Link Git repository into Jira and run Full-sync (to pull all git data with pull requests as well)

   Verify correctness of data in DB

Verify with query:

SELECT pr."ID" AS "PR_ID" , pr.CREATED_ON AS "PR_CREATED_ON",  pr."NAME" AS "PR_NAME",  issue.ISSUE_KEY 
FROM "AO_E8B6CC_PULL_REQUEST" pr
JOIN "AO_E8B6CC_PR_ISSUE_KEY" issue ON pr."ID" = issue."PULL_REQUEST_ID"
ORDER BY issue.ISSUE_KEY, pr.CREATED_ON 

There should be assigned two different pull requests ID to DOS-1 ISSUE_KEY

Expected Results

When we go to Jira->DOS-1 (issue) and click on pull requests in development status we should see 2 pull requests

Actual Results

When we go to Jira->DOS-1 (issue) and click on pull requests in development status we will see only 1 pull request

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available