[Dbix-class] calling delete in a resultset with a join

[Jonas Alves]

Hello all,

I', triyng to call delete in a resultset with a join. like this:

    $schema->resultset('Movie')->search(
        { 'category.update_flag' => 'old' },
        { join => 'category' }
    )->delete;


The SQL I'm getting is:

DELETE FROM movie WHERE ( update_flag = ? ): 'old'

And I was expecting something like:

DELETE FROM movie LEFT JOIN category WHERE ( category.update_flag = ? ): 'old'

Is this a bug, or am I doing something wrong?

Cheers,
-- 
Jonas

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]