Re: [Dbix-class] Duplication of records in many-to-many prefetch

2013-05-02 Thread Peter Rabbitson
On Wed, May 01, 2013 at 06:16:57PM -0400, Shea Levy wrote: Hi all, In my project, a user can have multiple roles and multiple users can have the same role. The username is the primary key for the users table. When I run a query like: -search({ 'me.username' = $username}, { columns

Re: [Dbix-class] Duplication of records in many-to-many prefetch

2013-05-02 Thread Shea Levy
On 05/02/2013 02:25 AM, Peter Rabbitson wrote: On Wed, May 01, 2013 at 06:16:57PM -0400, Shea Levy wrote: Hi all, In my project, a user can have multiple roles and multiple users can have the same role. The username is the primary key for the users table. When I run a query like: -search({

[Dbix-class] Duplication of records in many-to-many prefetch

2013-05-01 Thread Shea Levy
Hi all, In my project, a user can have multiple roles and multiple users can have the same role. The username is the primary key for the users table. When I run a query like: -search({ 'me.username' = $username}, { columns = [ me.fullname, me.emailaddress, me.username, userroles.role