[Dbix-class] Query is NOT created successfully.

2012-12-17 Thread dkim
Hello, When I use DBIx::Class::ResultSet::search() method with a complex query with multiple joins, the query produced from DBIx::Class is not complete. Some conditions are missing in the SQL query when I check the SQL. If I test it with each condition separately, then SQL is OK with that conditi

Re: [Dbix-class] Query is NOT created successfully.

2012-12-18 Thread Peter Rabbitson
On Mon, Dec 17, 2012 at 01:50:06PM -0800, dkim wrote: > Hello, > > When I use DBIx::Class::ResultSet::search() method with a complex query with > multiple joins, the query produced from DBIx::Class is not complete. Some > conditions are missing in the SQL query when I check the SQL. If I test it