[Koha-bugs] [Bug 21622] Incorrect GROUP BY clause in acqui/ scripts

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Oct 30 17:30:27 CET 2018


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

Julian Maurice <julian.maurice at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Failed QA
                 CC|                            |julian.maurice at biblibre.com

--- Comment #4 from Julian Maurice <julian.maurice at biblibre.com> ---
The SQL queries have a JOIN clause with aqorders_items. Without the GROUP BY it
can return multiple rows for the same order. It shouldn't be removed.

On master, ordered.pl displays a table of 15 rows
With the patch applied, it displays a table of 22 rows
Same thing on spent.pl with different numbers.

Failed QA

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


More information about the Koha-bugs mailing list