[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 #11 from Fridolin Somers <fridolin.somers at biblibre.com> ---
(In reply to Michael Hafen from comment #10)
> (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.

Is there then a need to group by biblionumber ?

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