https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43102
--- Comment #5 from David Nind <[email protected]> --- Created attachment 202113 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=202113&action=edit Bug 43102: filter_by_available computes the set difference in Perl filter_by_available fetches every itemnumber of the set and of each not-available subset into memory, subtracts them with array_minus, and inlines the result into the final query as one OR clause per itemnumber. This patch keeps the whole operation in the database by chaining NOT IN subqueries for the not-available sets onto the availability conditions. Existing unit tests should prove the fixes have caused no regression in existing behavior. Test Plan: 1) Apply this patch 2) prove t/db_dependent/Koha/Items.t 3) Note all tests pass! 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/
