Author: Damien Regad <damien.regad@...>
Date: 2011-08-10 (Wed, 10 Aug 2011)
Fix #13228: SQL error in bugnote_api.php with PostgreSQL
ERROR: column "u.realname" must appear in the GROUP BY clause or be used in an
Bug was introduced in release 1.2.6, commit c4c0a01e1f715aea775a36d3a6c7bc8bd74b5b8b.
A new column was added to 2 SQL statements' SELECT clause, but the GROUP BY
was not updated to match.
This passed testing, as MySQL is more (too?) permissive and allows the SELECT
clause to refer to ungrouped columns that are not in aggregate functions.
This commit also removes unnecessary "u.id" column from the group by clause.
Get latest updates about Open Source Projects, Conferences and News.