#103578Add database default value support for TEXT, BLOB and JSON field types
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
- main 84748[TASK] Avoid long varchar() in pages table
- main 84658[TASK] Make type=link fields TEXT by default
- main 84025[TASK] Remove temporary bugfix from `PostgreSQLSchemaManager`
- main 83745[BUGFIX] Ensure correct default value normalization
- main 83556[FEATURE] Add MySQL default value support for TEXT, JSON and BLOB