Issue Feature Closed

#103578Add database default value support for TEXT, BLOB and JSON field types

Stefan Bürk 04/09/24, 15:42 updated 07/09/24, 15:37

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

Reviews 5