-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 8.19.1, 8.20.0
-
8.19
-
10
-
Severity 2 - Major
-
1
Issue Summary
Steps to Reproduce
- Create a group with at least one upper case Cyrillic character in its name. For instance: Группа
- Assign a user to the group.
- Use the group in the assignable permissions for a project.
Expected Results
The user should appear in the Assignee dropdown.
Actual Results
The user doesn't appear. However, if the full username is typed, the user can be assigned the issue.
Workaround
Lower all the names of groups that have Cyrillic characters in the permissions or project roles tables. Here are the examples for Группа:
UPDATE projectroleactor SET roletypeparameter = 'группа' WHERE roletypeparameter = 'Группа';
UPDATE schemepermissions SET perm_parameter = 'группа' WHERE perm_parameter = 'Группа';
Other notes
The bug was identified to be caused by a LOWER() clause in a SQL query that doesn't effectively lower the case for Cyrillic characters while computing the assignable permissions.