[Koha-bugs] [Bug 20144] Test suite is failing with new default SQL modes

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Feb 12 12:57:40 CET 2018


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

--- Comment #48 from Julian Maurice <julian.maurice at biblibre.com> ---
Created attachment 71448
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=71448&action=edit
Bug 20144: [sql_modes] Fix GROUP BY clause in GetBasketsInfosByBookseller

This need to be tested from the interface!

Fix for:
'koha_kohadev.aqbasket.basketname' isn't in GROUP BY

t/db_dependent/Acquisition/GetBasketsInfosByBookseller.t

We need this group by.
We should not need to list all fields, from mysql 5.7 doc:
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
"The query is valid if name is a primary key of t or is a unique NOT NULL
column. In such cases, MySQL recognizes that the selected column is
functionally dependent on a grouping column. "

However, MariaDB did not implemented yet:
https://jira.mariadb.org/browse/MDEV-11588

Signed-off-by: Josef Moravec <josef.moravec at gmail.com>
Signed-off-by: Julian Maurice <julian.maurice at biblibre.com>

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


More information about the Koha-bugs mailing list