Crucible doesn't ensure its SQL DB is using case-sensitive comparisons

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 2.2-M1
    • Affects Version/s: 2.1.2
    • Component/s: None

      By default, MySQL creates Dbs with case insensitive comparisons (although our documentation specifies that case sensitive comparisons must be used)

      We don't check this, which can cause problems if a path is stored in one case and later occurs in a different case.

      e.g.:

      2009-12-01 20:58:33,242 ERROR [btpool0-310] org.hibernate.util.JDBCExceptionReporter org.hibernate.util.JDBCExceptionReporter-logExceptions - Duplicate entry 'FE-18870-48891' for key 2

      We need to check this configuration and report it with a banner (should this be on every page or just the admin page?)

            Assignee:
            Tom Davies
            Reporter:
            Tom Davies
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 4h
                4h