Bug 34223: (follow-up) Ensure consistent ordering of statuses
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Mon, 11 Sep 2023 13:50:43 +0000 (14:50 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Thu, 14 Sep 2023 18:23:44 +0000 (08:23 -1000)
commit9b1ff4d540e38c984d785ae10b56639163fe9633
treeb22eacd6b5da058c20f264ddc0d04d7884e8944a
parentedf7c6766128067ec8e28109f575c932e7707d48
Bug 34223: (follow-up) Ensure consistent ordering of statuses

This patch adds an order_by clause to ensure consistent ordering of the
returned status and status_alias statuses from the database between
MySQL 8 and other DB engines.

This fixes the failing tests introducd in bug 34223.

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 7f9ff906d9c2800fc5bf3d38db23a77e1f3745ab)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
Koha/Illbackend.pm