#110239Select/Radio/Checkbox option order in DB-stored forms reverts after reload on MySQL (JSON object key order not preserved)
Description
Since #108653, multi-value form elements persist their options as a JSON object (map keyed by option value) inside the form_definition.configuration JSON column. MySQL’s native JSON column type does not guarantee JSON object member order survives a write/read round trip (spec-compliant per RFC 8259), unlike MariaDB’s JSON type (a LONGTEXT alias, preserves order incidentally). Reordering options in the form editor appears to save correctly but reverts to the previous order on the next reload. Confirmed on MySQL 8.0.46, not reproducible on MariaDB 10.4.
Reviews 2
Related issues 2
History 49
-
Oliver Bartsch changed Related to #108653 <span data-processor="relativetime" data-value="2026-07-20T12:07:52+00:00" > 07/20/26, 12:07 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 94847 status
NewUnder Review <span data-processor="relativetime" data-value="2026-07-20T12:10:16+00:00" > 07/20/26, 12:10 </span> -
Josua Vogel changed Related to #110178 <span data-processor="relativetime" data-value="2026-07-20T16:33:09+00:00" > 07/20/26, 16:33 </span>
-
Gerrit Code Review pushed patch set 2 for main to change 94847 <span data-processor="relativetime" data-value="2026-07-20T16:33:37+00:00" > 07/20/26, 16:33 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 94847 <span data-processor="relativetime" data-value="2026-07-21T20:19:19+00:00" > 07/21/26, 20:19 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 94847 <span data-processor="relativetime" data-value="2026-07-22T00:54:09+00:00" > 07/22/26, 00:54 </span>
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 94878 <span data-processor="relativetime" data-value="2026-07-22T08:50:16+00:00" > 07/22/26, 08:50 </span>
-
Oliver Bartsch commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-07-22T08:55:09+00:00" > 07/22/26, 08:55 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2026-08-11T08:51:51+00:00" > 08/11/26, 08:51 </span>
Applied in changeset commit:40aacd262f028b1906f0e9551d6f6b45971b82b3.