[Dbix-class] Re: search on row-has_many fails if row has prefetch join, after 0.08196 - 0.08206 upgrade

2013-03-10 Thread Colin Dearing
I have tested this in our test suite with master at that time and can confirm it passes. Thanks for your help. On Sat, Feb 23, 2013 at 03:58:20AM +1100, Peter Rabbitson wrote: On Fri, Feb 22, 2013 at 04:46:46PM +, Chisel wrote: At work we had to freeze our DBIC at 0.08196 until the

Re: [Dbix-class] Re: search on row-has_many fails if row has prefetch join, after 0.08196 - 0.08206 upgrade

2013-03-10 Thread Peter Rabbitson
On Sun, Mar 10, 2013 at 02:36:49PM +, Colin Dearing wrote: I have tested this in our test suite with master at that time and can confirm it passes. Aye, we shipped it as 0.08209 since - too risky to let langish. By the way 0.08242 is available - please test and report ;)

[Dbix-class] RE: Search with complex joins generating bad SQL

2010-03-29 Thread Byron Young
` `hostname_2` ON ( `hostname_2`.`id` = `tested_host`.`hostname` ) WHERE ( `hostname_2`.`name` = ? ): 'gen-cs167' -Original Message- From: Ihnen, David [mailto:dih...@amazon.com] Sent: Monday, March 29, 2010 6:08 PM To: DBIx::Class user and developer list Subject: [Dbix-class] RE: Search

[Dbix-class] Re: search NOT IN

2009-07-06 Thread Tom Hukins
On Mon, Jul 06, 2009 at 04:26:27PM +0200, Stuart Dodds wrote: For example, the sql I would like to produce is as follows: WHERE id NOT IN (?,?,?) Assuming you use a recent version of SQL::Abstract, see:

Re: [Dbix-class] Re: search NOT IN

2009-07-06 Thread Stuart Dodds
On Mon, Jul 06, 2009 at 04:26:27PM +0200, Stuart Dodds wrote: For example, the sql I would like to produce is as follows: WHERE id NOT IN (?,?,?) Assuming you use a recent version of SQL::Abstract, see: