[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