Project

General

Profile

Actions

Bug #103610

closed

Ensure correct default value normalization for MySQL

Added by Stefan Bürk about 1 month ago. Updated about 1 month ago.

Status:
Resolved
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.


Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Feature #103578: Add database default value support for TEXT, BLOB and JSON field typesResolvedStefan Bürk2024-04-09

Actions
Related to TYPO3 Core - Task #103730: Remove temporary bugfix from `PostgreSQLSchemaManager`ResolvedStefan Bürk2024-04-25

Actions
Actions

Also available in: Atom PDF