https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1750 --- Comment #7 from M. Tompsett <mtompset@hotmail.com> --- Comment on attachment 49762 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=49762 Bug 1750 - Report bor_issues_top erroneous and truncated results. Review of attachment 49762: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=1750&attachment=49762) ----------------------------------------------------------------- ::: reports/bor_issues_top.pl @@ +279,4 @@
my $strcalc ;
# Processing average loanperiods + $strcalc .= "SELECT CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname), COUNT(*) AS RANK, borrowers.borrowernumber AS ID";
http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_concat... Nice! CONCAT_WS skips NULL entries, but still concat's, while CONCAT gives up and returns NULL. -- You are receiving this mail because: You are watching all bug changes.