[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