Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-23844

Add unique constraint for ID in GB_GRADE_RECORD_T

    XMLWordPrintable

    Details

    • Type: Feature Request
    • Status: CLOSED
    • Priority: Minor
    • Resolution: Non-Issue
    • Affects Version/s: 2.9.2
    • Fix Version/s: None
    • Component/s: Gradebook Classic
    • Labels:
      None
    • Conversion Script Required:
      Yes

      Description

      I suggest adding a unique constraint to the ID field of GB_GRADE_RECORD_T. In practice this field seems to be unique. Duplicate IDs can cause problems, e.g.

      ID=123 student_id=s1 gradable_object_id=10 score=10
      ID=123 student_id=s2 gradable_object_id=11 score=10

      Trying to change s2's score to 15 can cause a violation of CONSTRAINT GB_GRADE_RECORD_T_U2 UNIQUE (GRADABLE_OBJECT_ID, STUDENT_ID), since the database may try to update the earlier record.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                jswink Joshua Swink
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration