https://bugzilla.wikimedia.org/show_bug.cgi?id=25084
Summary: Update FlaggedRevs for new categorylinks schema Product: MediaWiki extensions Version: any Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: Normal Component: FlaggedRevs AssignedTo: jschulz_4...@msn.com ReportedBy: simetrical+wikib...@gmail.com CC: innocentkil...@gmail.com FlaggedRevs uses cl_sortkey, so it might be broken by the categorylinks changes <http://lists.wikimedia.org/pipermail/wikitech-l/2010-July/048399.html>. I looked at the code and wasn't immediately sure what it was doing, so I wasn't sure how to fix it. If someone who knows more about FlaggedRevs could either fix it or say what needs to be done or say what FlaggedRevs uses categorylinks for, please do. Important changes are: 1) The (cl_to, cl_sortkey, cl_from) index was changed to (cl_to, cl_type, cl_sortkey, cl_from). This means that SELECT ... WHERE cl_to = 'Foo' ORDER BY cl_sortkey; will cause a filesort. It would need to be changed to ORDER BY cl_type, cl_sortkey, or have AND cl_type = 'page' added, or something. (cl_type is a new ENUM equal to either 'page', 'subcat', or 'file' depending on the namespace of cl_from.) Likewise if you have offsets, those would need to include cl_type too to use the index properly. 2) cl_sortkey is now a binary string, at least in principle. Right now it's mostly text but could have embedded nulls; in the future it will likely be changed to pure binary sortkeys generated by CLDR or something. If you're printing these or anything, don't. Possibly no changes are needed, I'm not sure. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l