[Koha-bugs] [Bug 22812] Cannot add new subscription with strict SQL modes turned on

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #16 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Marcel de Rooy from comment #10)
> SELECT count(routingid) routingids FROM subscription LEFT JOIN
> subscriptionroutinglist ON subscription.subscriptionid =
> subscriptionroutinglist.subscriptionid order by ranking asc;
> 
> does not raise a warning with me on mariadb with sql mode:
> STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,
> NO_ENGINE_SUBSTITUTION
> 
> Do I overlook a setting?

MariaDB [koha_kohadev]> SET sql_mode =
'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Query OK, 0 rows affected (0.01 sec)

MariaDB [koha_kohadev]> SELECT count(routingid) routingids FROM subscription
LEFT JOIN subscriptionroutinglist ON subscription.subscriptionid =
subscriptionroutinglist.subscriptionid WHERE subscription.subscriptionid = 1
ORDER BY ranking ASC;
ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no
GROUP columns is illegal if there is no GROUP BY clause

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