https://bugzilla.wikimedia.org/show_bug.cgi?id=47055

--- Comment #6 from Tyler Romeo <[email protected]> ---
(In reply to comment #5)
> The problem is that PG *does* support FOR UPDATE, just limits it to cases
> that
> make sense.

Then maybe an exception should be thrown instead, as a warning to developers
that you shouldn't be doing FOR UPDATE on outer joins.

(In reply to comment #5)
> Why is the userJoinCond a LEFT JOIN when you're fetching rows for logged-in
> users which should have a row in the users table?

The issue is that the row doesn't necessarily exist in the user table. If the
revision was made by an anonymous user, then there will be no corresponding
row. The idea is to fetch the user row if it exists.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to