search

pietermartin / sqlg

TinkerPop graph over sql
MIT License
246 stars 51 forks source link

bulk update fails on "id" column #328

Closed pietermartin closed 5 years ago

pietermartin commented 5 years ago

Bulk update fails as Sqlg's generated sql uses id as the values statement join.

This is what Sqlg currently generates and if fails with column reference "id" is ambiguous

UPDATE "public"."V_A" a 
SET
    "id" = 
    (v."id")
FROM (
VALUES
    (1, 'haloagain')
) AS v(id, "id")
WHERE a."ID" = v.id