Open edstef opened 3 months ago
@edstef
It seems to work as expected if you change the query to be passed to the Join method from the Join
clause to the From
clause as shown below(I can't guarantee that it will work correctly since I haven't actually tested it).
Join("INNER JOIN games ON player_game_relations.game = game.id")
↓
Join("From games ON player_game_relations.game = game.id")
I see in https://github.com/uptrace/bun/pull/908 that there is a feature for update query with join. I updated to
github.com/uptrace/bun v1.1.17
and I get no golang errors but do get errors from postgres:My code:
In postgres it says to update join using
FROM
clause but bun doesn't support that on update query. From postgres logs the full statement is: