[mantisbt-commits] [mantisbt/mantisbt] 96532d: Fix #13228: SQL error in bugnote_api.php with Post...

  Branch: refs/heads/master
  Home:   https://github.com/mantisbt/mantisbt

  Commit: 96532dbea0da2f0e42749ccb040a6223954c08cc
      https://github.com/mantisbt/mantisbt/commit/96532dbea0da2f0e42749ccb040a6223954c08cc
  Author: Damien Regad <damien.regad@...>
  Date:   2011-08-10 (Wed, 10 Aug 2011)

  Changed paths:
    M core/bugnote_api.php

  Log Message:
  -----------
  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
aggregate function

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.

------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model 
configuration take the hassle out of deploying and managing Subversion and 
the tools developers use with it. Learn more about uberSVN and get a free 
download at:  http://p.sf.net/sfu/wandisco-dev2dev