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