Open leogdion opened 2 years ago
@leogdion could you enable debug logging and add the generated SQL?
cc @gwynne
DELETE
queries which require joins (also known as multi-table delete) are not currently supported by Fluent (or even by SQLKit), due to the lack of consistent support or syntax between different databases. Reclassifying as a high-priority feature request.
Experienced the same issue. Probably reported in the wrong place but here it is: https://github.com/vapor/fluent/issues/748 I added logs and examples of the corresponding SELECT query in the OP.
Feel free to close it if not useful.
Describe the bug
Anytime a
join
orwith
are involved in a delete query, I receive the follow error:Here's an example of query which fails:
Here's the workaround
In both cases
WorkoutGroup
is a parent ofWorkoutSchedule
.To Reproduce
Packages in use:
Expected behavior
Shouldn't need to query
all
todelete
Environment