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

Assignments should have an index on the context id

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 12.0, 12.1, 12.2, 12.3, 19.0
    • Fix Version/s: 12.4, 19.0
    • Component/s: Assignments
    • Labels:
    • 12 status:
      Resolved
    • Conversion Script Required:
      Yes
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      The Assignments table should have an index on the Context as the context represents the site id that the assignment belongs to.

       

      ALTER TABLE ASN_ASSIGNMENT ADD INDEX `IDX_ASN_ASSIGNMENT_CONTEXT` (`CONTEXT`)

       

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

              duplicates

              Bug - A problem which impairs or prevents functionality of the product. SAK-40335 Missing index on CONTEXT for ASN_ASSIGNMENT

              • Major - Major loss of function or need for functionality in production in the near future.
              • RESOLVED

                Activity

                  People

                  • Assignee:
                    ern Earle R Nietzel
                    Reporter:
                    ern Earle R Nietzel
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Git Integration