https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29134 --- Comment #10 from David Nind <david@davidnind.com> --- (In reply to Nick Clemens from comment #6)
(In reply to David Nind from comment #5) .. That was a typo, it should be:" INSERT into borrowers(surname, firstname, branchcode, categorycode) SELECT surname, firstname, branchcode, categorycode FROM ( SELECT surname FROM borrowers ORDER BY rand() ) a,( SELECT firstname FROM borrowers ORDER BY rand() ) b,( SELECT branchcode FROM borrowers ORDER BY rand() ) c,( SELECT categorycode FROM borrowers ORDER BY rand() ) d LIMIT 50000
Thanks Nick - now works as expected, and was able to test. Before patch applied (koha-testing-docker): 19.71 s After: 1.81 s -- You are receiving this mail because: You are watching all bug changes.