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)
committerTomas Cohen Arazi <tomascohen@theke.io>
Tue, 12 Sep 2023 12:48:32 +0000 (09:48 -0300)
commit7f9ff906d9c2800fc5bf3d38db23a77e1f3745ab
tree720b5ae8df0d4855ef00cb9ba89d7c3a45ecba67
parentedb9787fc85752c636e0d982871c4b715a2e57d8
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>
Koha/Illbackend.pm