#109803[TASK] Adjust creation of indexes on junction tables
Description
- Remove redundant index on `uid_local`, as it is already covered by the composite primary key (`uid_local`, `uid_foreign`) or (`uid_local`, `uid_foreign`, `tablenames`, `fieldname`) if `tablenames` and `fieldname` are provided. A reverse lookup index on `uid_foreign` is sufficient, since it already includes the primary key columns.
- Add a unique index on (`uid_local`, `uid_foreign`) and include `tablenames` and `fieldname` columns if they are provided for the case when a primary key `uid` is needed. A reverse lookup composite index on (`uid_foreign`, `uid_local`) is created in this case.
This issue was automatically created from https://github.com/TYPO3/typo3/pull/641
Reviews 1
History 36
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 94037 status
NewUnder Review <span data-processor="relativetime" data-value="2026-05-08T09:51:05+00:00" > 05/08/26, 09:51 </span> -
Garvin Hicking changed Duplicated by #109801 <span data-processor="relativetime" data-value="2026-05-08T10:20:32+00:00" > 05/08/26, 10:20 </span>
-
Garvin Hicking changed Duplicated by #109802 <span data-processor="relativetime" data-value="2026-05-08T10:20:59+00:00" > 05/08/26, 10:20 </span>
-
Gerrit Code Review pushed patch set 2 for main to change 94037 <span data-processor="relativetime" data-value="2026-05-11T07:10:32+00:00" > 05/11/26, 07:10 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 94037 <span data-processor="relativetime" data-value="2026-06-09T21:46:59+00:00" > 06/09/26, 21:46 </span>
-
Anonymous commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-06-10T21:25:10+00:00" > 06/10/26, 21:25 </span>
Applied in changeset commit:5676731d224e2a13b743a62ec282e815c91e54d0.