Review main Merged

91556[BUGFIX] Allow `UUID` in `ext_tables.sql` using Doctrine `GuidType`

Stefan Bürk CR +2 V +2 Hard +469 −172 updated 11/24/25, 17:26

Commit message

TYPO3 supports to define the virtual database schema using
`ext_tables.sql` in extensions to provide manual definition
for the virtual database structure and overriding generated
database schema using defaults for TCA managed tables and
fields. The syntax of this files is based on `MySQL` DDL
syntax and there is no other way to provide specific DDL
for other platforms in TYPO3 yet.

This change now parses the `PostgreSQL` field type `UUID`
in the aforementioned and mapping it to the `GuidType` of
doctrine to allow instances using PostgreSQL to use the
specific type to mitigate database analyzer rounds trying
to switch it away in case required for specific tables.

This aims to improve performance with TCA `type=uuid`
on PostgreSQL setups.

Adding the parsing support for manual override is considered
as bugfix and the fallback for other platforms provided by
Doctrine (`CHAR(26)`) looks suiting enough for most cases,
at least as long generated uuid's have the fixed length of
`36`, for example like it is generated by the used symfony
uid component and versions `Uuid::v4()`, `Uuid::v6()` and
`Uuid::v7()`.

To make this cross platform compatible the type is added
to allowed type hints in field comments and guarded with
tests to keep them working, similar like it has been done
for the `JSON` field support.

Review

  • Code review CR +2 Done
    • Stefan Bürk +2
    • Simon Praetorius +1
    • Sven Liebert +1
  • Verified V +2 Done
    • Stefan Bürk +2
    • Simon Praetorius +1
    • Sven Liebert +1
    • core-ci +1 CI

Issues 1

Files 13

Review log 1013

  1. Stefan Bürk uploaded patch set 1 11/11/25, 14:47

  2. core-ci voted on patch set 1 V +1 11/11/25, 14:57 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/89015

  3. Simon Schaufelberger voted on patch set 1 CR +1 V +1 11/11/25, 19:00

  4. Garvin Hicking commented on patch set 1 CR +1 V +1 11/11/25, 23:38

    Nice! I only tested the "fallback" on mysql and otherwise ran this through the tests only.
    This aims to improve performance with TCA `type=uuid` on PostgreSQL setups.
    "for most cases"
  5. Garvin Hicking updated the commit message in patch set 2 CR +1 V +1 11/12/25, 08:50

  6. Garvin Hicking commented on patch set 2 CR +1 V +1 11/12/25, 08:50

    Reply

    Done

    Reply

    Done
  7. core-ci voted on patch set 2 V +1 11/12/25, 08:58 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/89168

  8. Garvin Hicking rebased onto patch set 3 CR +1 V +1 11/24/25, 16:33

  9. Sven Liebert voted on patch set 3 CR +1 V +1 11/24/25, 16:43

  10. core-ci voted on patch set 3 V +1 11/24/25, 16:43 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/90871

  11. Simon Praetorius voted on patch set 3 CR +1 V +1 11/24/25, 16:55

  12. Stefan Bürk voted on patch set 3 CR +2 V +2 11/24/25, 16:56

  13. Stefan Bürk merged patch set 4 11/24/25, 17:26