Bug #103610
closedEnsure correct default value normalization for MySQL
100%
Description
Default value support for TEXT, JSON and BLOB fields
has been added with #103578 by implementing the use
of default value expression for MySQL. That required
to add custom normalization on data schema reads to
be comparable.
MySQL requires to use a single-quote to quote a single
quote in a value string, and due to the expression way
this needs to be properly decoded now in two steps:
- Revert escape sequences in the retrieved default value
- Unquote the unescaped retrieved default value
JSON field defaults shows a similar issue for double
quotes in the json value and can be fixed in the same
way.
Updated by Stefan Bürk 8 months ago
- Related to Feature #103578: Add database default value support for TEXT, BLOB and JSON field types added
Updated by Gerrit Code Review 8 months ago
- Status changed from New to Under Review
Patch set 3 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/+/83745
Updated by Gerrit Code Review 8 months ago
Patch set 4 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/+/83745
Updated by Gerrit Code Review 8 months ago
Patch set 5 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/+/83745
Updated by Gerrit Code Review 7 months ago
Patch set 6 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/+/83745
Updated by Gerrit Code Review 7 months ago
Patch set 7 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/+/83745
Updated by Gerrit Code Review 7 months ago
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/+/83745
Updated by Stefan Bürk 7 months ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset b23029d5ecbe1436ff4d7171f2ea60825b593ac4.
Updated by Stefan Bürk 7 months ago
- Related to Task #103730: Remove temporary bugfix from `PostgreSQLSchemaManager` added