Join ignored in update_all
dfrese opened this issue · 2 comments
dfrese commented
In a query like
MyRepo.update_all(
from(t1 in "table1",
join: t2 in "table2",
on: t1.id == t2.id
),
set: [value: 0]
)
the join clause seems to be completely ignored, and an SQL like
UPDATE table1 t0 SET value = 0
is executed.
I could achieve the same thing with a where: t1.id in subquery(...)
instead,
but I think at least an error should be generated, as the SQL is very different from the Ecto query.