https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #12 from Marc A. Pelletier <[email protected]> --- (In reply to Aaron Halfaker from comment #9) > Marc, as a regular user of this data, that's very unintuitive. Indeed it is, albeit clearly documented at: https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help#Tables_for_revision_or_logging_queries_involving_user_names_and_IDs This is what I meant by 'least surprise'; if you use the revision view, you get the expected (every row) result. If you have a where clause on rev_user or rev_user_text (that isn't IS NULL for the obvious reason) then you *also* get every row you would have gotten from revision. The unintuitive result occurs /only/ if you use revision_userindex while not also selecting on the value of rev_user. This is why the _userindex table was not made the default. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
