Feature #103578
closed
Add database default value support for TEXT, BLOB and JSON field types
100%
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 Gerrit Code Review 8 months ago
- Status changed from New to Under Review
Patch set 8 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83556
Updated by Gerrit Code Review 8 months ago
Patch set 9 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83556
Updated by Gerrit Code Review 8 months ago
Patch set 10 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83556
Updated by Gerrit Code Review 8 months ago
Patch set 11 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83556
Updated by Gerrit Code Review 8 months ago
Patch set 12 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83556
Updated by Gerrit Code Review 8 months ago
Patch set 13 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/83556
Updated by Stefan Bürk 8 months ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 8678920771ede4bb5fd895c2ff9edf3f7247a321.
Updated by Stefan Bürk 8 months ago
- Related to Bug #103610: Ensure correct default value normalization for MySQL added
Updated by Stefan Bürk 7 months ago
- Related to Task #103730: Remove temporary bugfix from `PostgreSQLSchemaManager` added
Updated by Christian Kuhn 5 months ago
- Related to Task #104068: Make type=link fields TEXT by default added
Updated by Christian Kuhn 5 months ago
- Related to Task #104138: Avoid long varchar() in pages table added
Updated by