Jira assignable user doesn't appear if they are a member of a group with upper case Cyrillic characters

XMLWordPrintable

    • 8.19
    • 10
    • Severity 2 - Major
    • 1

      Issue Summary

      Steps to Reproduce

      1. Create a group with at least one upper case Cyrillic character in its name. For instance: Группа
      2. Assign a user to the group.
      3. 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.

              Assignee:
              Artem Iurkov (Inactive)
              Reporter:
              Arbi Dridi
              Votes:
              10 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated: