Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PLUS_SUBJECT composite key is too big

Description

indexes = @Index(columnList = "SUBJECT, TENANT_GUID, SAKAI_USER_ID, EMAIL")

MySQL InnodB limit is 3072bytes. Each char is 3 bytes in utf8mb3 so we have 1024 chars

Activity

Show:

Automation for Jira March 19, 2024 at 2:59 PM

A pull request has been created, "SAK-49854 Plus: reduce column lengths to reduce composite key length", you can see it at https://github.com/sakaiproject/sakai/pull/12440

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Labels

Created March 19, 2024 at 2:56 PM
Updated April 5, 2024 at 3:31 PM
Resolved April 5, 2024 at 3:31 PM