[Dbix-class] select and DISTINCT

[Peter Rabbitson]

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