Perform additional check before groups to crowd migration to ensure fields have case sensitive collation

XMLWordPrintable

    • Type: Bug
    • Resolution: Not a bug
    • Priority: Medium
    • N/A
    • Affects Version/s: 4.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0
    • Component/s: None
    • None

      Upgrade task (MigrateGroupsToCwdGroups) requires cru_ps_group to be collated case-sensitive.
      Without ensuring that migrating database has proper collation set, it is possible to drop all group associations in permission schemes silently, without any warning.
      For reference, there is a query, which causes problems if fields have case non-sensitive collation: com/cenqua/crucible/hibernate/upgrade/crowd/MigrateGroupsToCwdGroups.java:112

      // permission scheme
      executeUpdate(conn, "DELETE FROM cru_ps_group WHERE cru_pid = ?", normalizedNewName);
      executeUpdate(conn, "UPDATE cru_ps_group SET cru_pid = ? WHERE cru_pid = ?", normalizedNewName, oldName);
      

              Assignee:
              Unassigned
              Reporter:
              Adam Borowski (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: