cascade destroy on has_many does not work correctly if the relationship has a parent filter

[barnabasJ]

Describe the bug
A clear and concise description of what the bug is. If you are not sure if the bug is related to ash or an extension, log it with ash and we will move it.

The query that is built to get the related record includes a select for the original record which is not in the db anymore because the destroy is executed in an after action

To Reproduce
A minimal set of resource definitions and calls that can reproduce the bug.

Expected behavior
A clear and concise description of what you expected to happen.

** Runtime

• Elixir version 1.18
• Erlang version 27
• OS Ubuntu
• Ash version 3.4.55
• AshPostgres main
• any related extension versions

Additional context
Add any other context about the problem here.

[zachdaniel]

Ah, interesting. We need to do it in a before hook if it's a destroy action then.

[zachdaniel]

I won't have time to get to this in the near future unfortunately.

[barnabasJ]

I can probably take a look sometime this week. I fixed my problem with some custom SQL at the moment to get unblocked. And I need to do some other things first.

[barnabasJ]

Still planning on doing this, just didn't find any time on the weekend