[Dbix-class] select and DISTINCT

Peter Rabbitson rabbit+dbic at rabbit.us
Tue Jun 11 21:18:25 GMT 2013

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.


More information about the DBIx-Class mailing list