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

          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 Source Code