Actions
Feature #103578
closed
Add database default value support for TEXT, BLOB and JSON field types
Status:
Resolved
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2024-04-09
Due date:
% Done:
100%
Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:
Description
MySQL supports default values for TEXT, JSON and BLOB
fields since 8.0.13+ [1], at least by using a quirky
expression. The other supported database vendor and
version already supported that.
With this addition, it is possible to enhance the TYPO3
database analyzer stack to support now default values
for these field types by transforming it to default
value expression for MySQL.
That allows to set default values on database level,
so inserts will regonize this if TYPO3 provided API
like Connection->insert() is not used or for tables
not managed by TCA.
[1] https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-13.html#mysqld-8-0-13-data-types
Updated by 
Updated by
Actions