[Koha-bugs] [Bug 21725] Incorrect HAVING in group by in Acquisitions.pm

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

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

--- Comment #7 from Nick Clemens <nick at bywatersolutions.com> ---
(In reply to Jonathan Druart from comment #6)
> I wanted to move the condition to the WHERE clause. The advantage to have it
> into the HAVING clause was to not repeat the condition. With this patch we
> c/p the condition and have it in the HAVING clause... :)

I tried moving things to the where, but this removed orders from the
total_orders count so I went this route.

I can confirm setting the modes as you explain and then running the query fails
for me

However: Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1

Possibly:
https://bugs.mysql.com/bug.php?id=51058

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