https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43125
--- Comment #2 from David Nind <[email protected]> --- Created attachment 203576 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=203576&action=edit Bug 43125: Bulk-update reserves in FixPriority This patch replaces the loop producing multiple UPDATE queries with one UPDATE query using CASE to update all reserve priorities at once. The previous query used a WHERE clause to only update rows where the value had changed. I believe this was done to avoid changing the timestamp column through its ON UPDATE, but MySQL will only do this if the value changes, so this clause is omitted for simplicity. Test plan: 1. Prove t/db_dependent/Reserves.t and verify no tests fail. Sponsored-by: ByWater Solutions Signed-off-by: David Nind <[email protected]> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected] website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
