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

JIRA is not fully compatible with case insensitive collation

XMLWordPrintable

      Steps to reproduce:

      1. Create JIRA db with case insensitive collation 
        CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_general_ci;
      2. Add two workflows, one called 'ABC' and the second one 'abc'.
      3. Create new workflow scheme e.g 'myscheme' and assign the 'ABC' workflow to it.
      4. If you navigate to the Workflows page, you notice that both workfows have been associated with the scheme.

      JIRA generates the association between the workflows and the scheme with help of following SQL queries:

      "SELECT ID, SCHEME, WORKFLOW, issuetype FROM workflowschemeentity WHERE WORKFLOW='ABC'"
"SELECT NAME, DESCRIPTION FROM workflowscheme WHERE ID='10020'"
"SELECT ID, SCHEME, WORKFLOW, issuetype FROM workflowschemeentity WHERE WORKFLOW='abc'"
"SELECT NAME, DESCRIPTION FROM workflowscheme WHERE ID='10020'"

        1. mockup.png
          mockup.png
          49 kB
        2. mysql-utf8_bin.png
          mysql-utf8_bin.png
          12 kB
        3. scheme_association.png
          scheme_association.png
          32 kB
        4. workflow_scheme.png
          workflow_scheme.png
          11 kB
        5. workflow.png
          workflow.png
          31 kB

              Unassigned Unassigned
              bdziedzic Bogdan Dziedzic [Atlassian]
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: