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

JIRA is not fully compatible with case insensitive collation

    XMLWordPrintable

Details

    Description

      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'"

      Attachments

        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

        Issue Links

          is related to

          Suggestion - JRASERVER-21442 Incorrect character comparison between different collation for MySQL

          • Closed

          Suggestion - JRASERVER-42503 Recommended Collation for SQL Server Database

          • Closed
          relates to

          Suggestion - JRASERVER-21506 JIRA upgrade process is not fully compatible with case sensitive collation

          • Closed
          mentioned in

          Page Loading...

          Page Loading...

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: