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)
committerMatt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Fri, 15 Sep 2023 10:19:57 +0000 (10:19 +0000)
commitdddc3b83eae47e6fa6d509b2d9ddc3bffa9fec3d
treea46c4aa899b928cb726a4969c04a2c01a424ac1f
parent37f342822a6249531864a8bd01227b9884b23051
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>
(cherry picked from commit 9b1ff4d540e38c984d785ae10b56639163fe9633)
Signed-off-by: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Koha/Illbackend.pm