On Tue, Jun 11, 2013 at 05:00:03PM +0400, Alex Povolotsky wrote: > On 06/11/13 16:43, Dmitry Belyavsky wrote: > > select => ['DISTINCT column'] clearly should not work with > DBIx::Class; and select distinct does not seems to be supported > well. > > distinct => 1 does something strange (group by instead of distinct),
This is because multi-column GROUP BY is supported by everything, while multicolumn DISTINCT is a rather proprietary thing. On systems supporting both, the result is the same - collapsing the entire resultset to a small amount of distinct records. Cheers _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
