https://bugzilla.wikimedia.org/show_bug.cgi?id=47055
Web browser: ---
Bug ID: 47055
Summary: Revision::fetchFromConds SELECT ... FOR UPDATE invalid
in Postgres
Product: MediaWiki
Version: 1.21-git
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Mobile Platform: ---
===
Apr 9 20:39:11 thedarkcitadel postgres[21778]: [3-1] 2013-04-09 20:39:10 UTC
ERROR: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an
outer join
Apr 9 20:39:11 thedarkcitadel postgres[21778]: [3-2] 2013-04-09 20:39:10 UTC
STATEMENT: SELECT /* Revision::fetchFromConds 127.0.0.1 */
rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name
FROM "unittest_revision" INNER JOIN "unittest_page" ON ((page_id = rev_page))
LEFT JOIN "unittest_mwuser" ON ((rev_user != 0) AND (user_id = rev_user))
WHERE page_id = '649' AND rev_id = '1055' LIMIT 1 FOR UPDATE
===
This is likely what is breaking other phpunit tests
--
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
