[Koha-bugs] [Bug 28977] Most-circulated items (cat_issues_top.pl) is failing with SQL Mode ONLY_FULL_GROUP_BY

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28977

--- Comment #10 from Michael Hafen <michael.hafen at washk12.org> ---
(In reply to Fridolin Somers from comment #9)
> Do we still need "DISTINCT" on biblio.title ?

Maybe so; depends on how likely it is that separate biblios will have the same
title, and whether the library would want those separate records grouped
together.
In my case, we'd probably want the records grouped together.  I tried the query
in MySQL 8.0 with and without the 'DISTINCT', and there was 1 row difference. 
Though my case is probably not typical, being a school district with a bunch of
schools that migrated from separate databases into one instance of Koha.

-- 
You are receiving this mail because:
You are watching all bug changes.