Did you test removing the DISTINCT line on MSSQL?

IIRC, I think it was that DB engine where we've needed to add it before.

We probably shouldn't remove it unless we've tested it on all the DB engines we support.


On Wed, Aug 28, 2013 at 11:17 PM, GitHub <noreply@github.com> wrote:
  Branch: refs/heads/master
  Home:   https://github.com/mantisbt/mantisbt
  Commit: 5c4f817aac166f8fd9565eeba6cd88921c070610
      https://github.com/mantisbt/mantisbt/commit/5c4f817aac166f8fd9565eeba6cd88921c070610
  Author: Damien Regad <dregad@mantisbt.org>
  Date:   2013-08-28 (Wed, 28 Aug 2013)

  Changed paths:
    M core/filter_api.php

  Log Message:
  -----------
  Remove useless code


  Commit: 044133b367234e0e46976dff6d4602b9e8338e72
      https://github.com/mantisbt/mantisbt/commit/044133b367234e0e46976dff6d4602b9e8338e72
  Author: Markus Schneider <schnueptus@schnueptus.de>
  Date:   2013-08-28 (Wed, 28 Aug 2013)

  Changed paths:
    M core/filter_api.php

  Log Message:
  -----------
  When sorting by due_date, display undefined values last

Markus' original patch was modified to simplify the code and reduce
duplication, fix a couple typos in comment text and reword the
commit message.

Fixes #16259


  Commit: 9c57416cc20d82cb6af1ff6852011e33f988981b
      https://github.com/mantisbt/mantisbt/commit/9c57416cc20d82cb6af1ff6852011e33f988981b
  Author: Damien Regad <dregad@mantisbt.org>
  Date:   2013-08-28 (Wed, 28 Aug 2013)

  Changed paths:
    M core/filter_api.php

  Log Message:
  -----------
  Remove DISTINCT clause from filter_get_bug_rows query

Fixes #16259 PostgreSQL error when filtering by due_date ASC


Compare: https://github.com/mantisbt/mantisbt/compare/65835d64a79e...9c57416cc20d

------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
mantisbt-cvs mailing list
mantisbt-cvs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mantisbt-cvs