Cannot remove group from default project role members when added with wrong case

Summary

Unable to remove group from default member of project role when group was added using different case than actual group name.
 

Steps to Reproduce

Example 1:

1. Create a local mixed case group, example: abCd
2. Go to Administration > System > Project roles
3. Choose any of the project roles, then click on Manage Default Members
4. Under Default Groups click on Edit
5. Add the group by typing the group name abcd in the text field
6. Try to remove the group

Example 2:

1. Create a lower case group, example: testgroup
2. Go to Administration > System > Project roles
3. Choose any of the project roles, then click on Manage Default Members
4. Under Default Groups click on Edit
5. Add the group by typing the group name in the text field. Type group name using upper case or mixed case.
6. Try to remove the group

Expected Results

Group will be removed

Actual Results

Group cannot be removed. Attempting to remove group causes page to refresh, group does not get removed.

Notes

• The Bug does not affect mixed case groups alone. It affects all groups (jira-software-users is affected if you enter Jira-Software-Users)
• The problem occurs when the case of the group name entered into the text field does not exactly match the name of the group
  • Group name foo; you enter foo
  • Group name foo; you enter Foo
  • Group name Foo; you enter Foo

Workaround

To prevent this issue, add the group via the group picker instead of typing name.

To remove groups that cannot be removed in the UI: (Server only)

1. Obtain ID of role that needs to be edited
   • On the page where you remove the group, look at the URL and note "projectRoleId" that appears
2. Back up your data
3. Shutdown JIRA
4. In database, SELECT * FROM projectroleactor WHERE pid IS NULL and projectroleid = <projectRoleId>;
   • Replace <projectRoleId> with the ID obtained in step 1.
   • This will return the entries for that project role.
5. For each entry that needs to be removed:
   • DELETE FROM projectroleactor WHERE id = <id of row>;
   • Replace <id of row> with the ID of the row that contains the group name that needs to be removed.
6. Start JIRA
7. Navigate to default project role members page and confirm appropriate groups appear.

Cloud customers should contact support to have the group(s) removed.