https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21725
--- Comment #7 from Nick Clemens <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
