Review 13.4 Merged

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

Stefan Bürk CR +2 V +2 Hard +461 −165 updated 11/24/25, 17:27

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
  • Verified V +2 Done
    • Stefan Bürk +2
    • core-ci +1 CI

Issues 1

Files 13

Review log 34

  1. Stefan Bürk uploaded patch set 1 11/24/25, 17:19

  2. core-ci voted on patch set 1 V +1 11/24/25, 17:26 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/90876

  3. Stefan Bürk voted on patch set 1 CR +2 V +2 11/24/25, 17:27

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