erlangbureau/jamdb_oracle

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.

test "CTE update_all"