Bug 20144: [sql_modes] Remove HAVING clause in GetLateOrders
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 5 Feb 2018 20:38:32 +0000 (17:38 -0300)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 13 Feb 2018 16:58:53 +0000 (13:58 -0300)
commitecc69f0ab24c926696ae1c537589801e0f41d9b5
treed6a81d9b3fa2a53e65b5f4ab964bacb16e7cc9db
parentf854d16def40a97df326e356063bd931d03c3032
Bug 20144: [sql_modes] Remove HAVING clause in GetLateOrders

More attention needed here!

Fix for:
Non-grouping field 'quantity' is used in HAVING clause

Having is useless, and certainly slower

t/db_dependent/Acquisition.t

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
C4/Acquisition.pm