[Dbix-class] as_subselect_rs->delete bug?

Toby Corkindale toby at dryft.net
Wed Jul 11 05:23:24 GMT 2012


Hi,
I discovered what smells like a bug in the as_subselect_rs codepath,
but it may just me doing it wrong..

The Perl code looks like this:

    $schema->resultset('Step')->search(
        {
            file_id => $file_id,
            'stage.name' => 'Final',
        },
        { join => 'stage' }
    )->as_subselect_rs->delete;

However the generated SQL is simply:

    DELETE FROM step WHERE ( file_id = ? )

It seems to have lost the join altogether.

This was on version 0.08196 but I can try on a later one in a moment.

-Toby



More information about the DBIx-Class mailing list