Issue Bug Closed

#103610Ensure correct default value normalization for MySQL

Stefan Bürk 04/11/24, 13:26 updated 07/09/24, 15:37

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.

Reviews 2