JIRA to support MSSQL case-sensitive database

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 6.1.5
    • Component/s: Installation
    • 6.01
    • 3
    • Severity 3 - Minor
    • 1

      MSSQL has a known problem with distinguishing between the data and the metadata when you the database is set to case-sensitivity. For example:

      -- This  SQL query won't work 
      SELECT table_name, table_type FROM information_schema.tables;
      GO 
      -- This SQL query will work
      SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES;
      GO
      

      This is because the object name is actually INFORMATION_SCHEMA.TABLES.

      This has forced our documentation to recommend case-insensitivity for MSSQL database. In the other hand, using case-insensitivity database is known to break a couple of functionality in JIRA, to name a few:

      1. https://jira.atlassian.com/browse/JRA-30151
      2. https://jdog.atlassian.net/browse/JRADEV-15936

            Assignee:
            Unassigned
            Reporter:
            vkharisma
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: