Bug #100101
closedAvoid invalid default value for auto created native database json field
100%
Description
With #100088 the `json` field handling has been changed from
TCA `dbType = json` to `type = json` along with automatic db
field creation, if not provided by `ext_tables.sql`.
`\TYPO3\CMS\Core\Database\Schema\DefaultTcaSchema` has been
changed to create a native json field with the default value
of '[]' if not manually provided. MariaDB allows setting of
default value for `text` and `json`fields, the competitor
`MySQL` not. Many developers are not aware of this difference.
`doctrine/dbal` does not help to avoid invalid field defaults.
Updated by Gerrit Code Review about 1 year ago
- Status changed from New to Under Review
Patch set 1 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/+/78043
Updated by Stefan Bürk about 1 year ago
- Related to Feature #100088: Introduce TCA type json added
Updated by Stefan Bürk about 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 0fff35944f469976873426bac23b0d1ce65af34a.
Updated by Oliver Bartsch about 1 year ago
- Related to Task #100156: Set TCA default for type "json" via TcaPreparation added