#110425Reduce column type comment handling to MySQL
Description
With SQLite declaring dedicated JSON and UUID column types (sub-task 3), the doctrine type hint comment is only needed for a single type on a single platform family: neither MySQL nor MariaDB – including 11.7, which doctrine does not map to its native UUID type – offer a declaration that tells a GUID apart from any other CHAR(36). PostgreSQL never needed the comment, it has native json, jsonb and uuid types.
Fix
Keep the type comment where it is needed and remove TYPO3\CMS\Core\Database\Platform\PostgreSQLPlatform and PostgreSQL120Platform together with their entries in the driver middleware. Both only carried GetColumnDeclarationSQLCommentTypeAwareTrait and are empty without it, both are annotated internal@, and both were only ever instantiated there.
typeRequiresCommentHint() no longer needs its platform to type map either; the trait is used by the extended MySQL and MariaDB platforms only, so a plain type check is left and the reasoning why no other platform or type qualifies is documented in place.
Existing installations
Introspection keeps resolving an existing type comment on all platforms. Installations created before this still carry them, and the extended schema managers map those columns back to the same doctrine type. This is documented as Important, not as Breaking.
Supersedes the intent of Gerrit 93670.
Patch
Gerrit 95190, topic database-analyzer.
Releases: main
Reviews 1
History 09
-
Gerrit Code Review pushed patch set 3 for main to change 95190 status
NewUnder Review <span data-processor="relativetime" data-value="2026-08-11T04:01:00+00:00" > 08/11/26, 04:01 </span> -
Gerrit Code Review pushed patch set 4 for main to change 95190 <span data-processor="relativetime" data-value="2026-08-11T05:17:38+00:00" > 08/11/26, 05:17 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 95190 <span data-processor="relativetime" data-value="2026-08-11T11:38:30+00:00" > 08/11/26, 11:38 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 95190 <span data-processor="relativetime" data-value="2026-08-11T13:29:36+00:00" > 08/11/26, 13:29 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 95190 <span data-processor="relativetime" data-value="2026-08-11T14:14:18+00:00" > 08/11/26, 14:14 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 95190 <span data-processor="relativetime" data-value="2026-08-14T20:49:00+00:00" > 08/14/26, 20:49 </span>
-
Gerrit Code Review pushed patch set 9 for main to change 95190 <span data-processor="relativetime" data-value="2026-08-31T10:29:07+00:00" > 08/31/26, 10:29 </span>
-
Gerrit Code Review pushed patch set 10 for main to change 95190 <span data-processor="relativetime" data-value="2026-09-02T10:40:48+00:00" > 09/02/26, 10:40 </span>
-
Gerrit Code Review pushed patch set 11 for main to change 95190 <span data-processor="relativetime" data-value="2026-09-02T13:16:41+00:00" > 09/02/26, 13:16 </span>