[Dbix-class] Re: as_subselect_rs->delete bug?

[Toby Corkindale]

If it helps, the SQL I would have expected would be something like:

      DELETE FROM step
      USING stage
      WHERE step.stage_id = stage.id
      AND stage.name = 'Final'
      AND step.file_id = ?

Although now I think about it, it's probably hard to get to that from
a subselect_rs.

So maybe I'd expect something like

DELETE FROM step
WHERE id IN (
  SELECT id FROM step
  JOIN stage ON (step.stage_id = stage.id)
  WHERE step.file_id = ?
  AND stage.name = 'Final'
);

On 11 July 2012 15:28, Toby Corkindale <toby at dryft.net> wrote:
> On 11 July 2012 15:23, Toby Corkindale <toby at dryft.net> wrote:
>> This was on version 0.08196 but I can try on a later one in a moment.
>
> Just confirming it still happens on 0.08198.
>
> --
> Turning and turning in the widening gyre
> The falcon cannot hear the falconer
> Things fall apart; the center cannot hold
> Mere anarchy is loosed upon the world



-- 
Turning and turning in the widening gyre
The falcon cannot hear the falconer
Things fall apart; the center cannot hold
Mere anarchy is loosed upon the world