Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: SSP 2.0.0, SSP 2.1.0, SSP 2.0.1
    • Fix Version/s: SSP 2.1.0, SSP 2.0.1
    • Component/s: Database
    • Labels:
      None

      Description

      Except for student search by school_id, all person and external_person lookups by username or school_id appear to be case-sensitive in Postgres deployments. This is almost certainly not what a deployer typically wants by default and has already caused a problem with the North Carolina schools. At a minimum, lookups need to compare these fields case-insensitively, but we really should also force these fields to consistent casing in the db in order to properly take advantage of uniqueness constraints. Postgres might let us set up function-based indexes/constraints, though.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                aarland Anthony Arland
                Reporter:
                dmccallum Dan McCallum
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: