From e9889ea0f202f32f51eb6c89eed1d2f3cbf54f1d Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Tue, 7 Jan 2025 16:43:44 +0000 Subject: [PATCH] Bug 38646: (QA folllow-up) Fix ONLY_FULL_GROUP_BY We can use a plain AND in the WHERE clause here rather than requireing a HAVING. Signed-off-by: Martin Renvoize --- C4/Languages.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Languages.pm b/C4/Languages.pm index 28e8286c561..e84aa1418a3 100644 --- a/C4/Languages.pm +++ b/C4/Languages.pm @@ -200,7 +200,7 @@ sub getLanguages { } my $language_list = $isFiltered ? C4::Context->preference("AdvancedSearchLanguages") : undef; - my $language_list_cond = $language_list ? 'HAVING FIND_IN_SET(language_rfc4646_to_iso639.iso639_2_code, ?)' : ''; + my $language_list_cond = $language_list ? 'AND FIND_IN_SET(language_rfc4646_to_iso639.iso639_2_code, ?)' : ''; my $sth = $dbh->prepare(" SELECT -- 2.39.5