[Dbix-class] Join and Precache not producing what I expect.

[Matt S Trout]

On Mon, Sep 24, 2007 at 01:13:48PM +0100, Curtis Fletcher wrote:
> Hi all.
> I've been using Catalyst/DBIx::Class for a few months now. Being used to
> rolling my own SQL the hardest part was getting to grips with an ORM,
> but I think I'm just about there now, but I'm getting some odd results
> when precaching results.
> 
> Apologies for the length but I've reduced this down as much as I can.
> 
> The problem is that I'm getting more objects that I would expect from
> the DBIx:Class during precaching, the SQL that is generated looks fine
> and gives me the rows I'd expect. But the conversion of those result
> rows seems to be wrong given the classes I've defined. I'm guessing this
> is a bug. I've come across a few of them with some of my joins that
> disappeared as I upgraded DBIx:Class (Usually just as I'd got a test
> case and were prepping an email to the list :) )

You can't prefetch more than one has_many at the same level currently;
known issue and we're working on it.

What's confusing me more is that you didn't just get an exception, but either
way the answer is "I'm really sorry but that doesn't work just yet, we'll
get to it as soon as we can".

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/