Bug 20179: [sql_modes] Remove GROUP BY in get_shelves_containing_record
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 6 Feb 2018 14:04:50 +0000 (11:04 -0300)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 9 Apr 2018 19:15:17 +0000 (16:15 -0300)
commit7e220e0d8f107cce63f32bfaa1919c04b4dea6e2
tree746fef3f413782277e35fba7aba80d049576eff8
parent76eb3a0549efe4c1f1557071a6cb4b33d4bd3e4d
Bug 20179: [sql_modes] Remove GROUP BY in get_shelves_containing_record

Replaced with distinct.
Fix for:
'koha_kohadev.me.shelfname' isn't in GROUP BY

t/db_dependent/Virtualshelves.t

Signed-off-by: Roch D'Amour <roch.damour@inlibro.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Koha/Virtualshelves.pm