Actions
Bug #103610
closedEnsure correct default value normalization for MySQL
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2024-04-11
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
13
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
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.
Actions