Issue Task Closed

#106549Mitigate database difference in json field test assertion

Stefan Bürk 04/10/25, 16:01 updated 12/02/25, 14:22

Description

Database vendors has different ways to work with native json
fields, so long supported, which includes different behaviours.
For example, `MariaDB` removes spaces between keys and values
in json data, while MySQL seems to resort json data in a weired
way or related behaviour.

This makes it hard, if not impossible, to assert database values
based on a single csv set accross different databases.

With #106532 tests has been added to verify the working state of
the upgrade wizard transforming serialized scheduler task data
into json fields and a nightly would fail executing MySQL, which
pre-merge does not and revealed to manual nightly run for another
change.

Reviews 1

History 37

  1. Stefan Bürk commented and changed status Under Review Resolved done 0 % 100 % <span data-processor="relativetime" data-value="2025-04-10T18:20:07+00:00" > 04/10/25, 18:20 </span>

    Applied in changeset commit:c2f346f5f45b0ccfdc94f07020cad0a837c638d3.