https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
Marc A. Pelletier m...@uberbox.org changed:
What|Removed |Added
Status|NEW |RESOLVED
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #4 from Marc A. Pelletier m...@uberbox.org ---
The naming convention was selected on the least surprise principle; there are
a number of rows not available in the _%index views and those rows would be
missing without explanation.
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #5 from Yuvi Panda yuvipa...@gmail.com ---
Yeah, I think the rename will actually give people the 'least surprise' - I
think running a query you expect to be fast but ends up being super slow and
then having to go dig around why is
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #6 from Marc A. Pelletier m...@uberbox.org ---
That's not what I meant (performance); currently selection on 'revision' will
give you the same result rows as making that same query in production whereas
use of 'revision_userindex'
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #7 from Aaron Halfaker aaron.halfa...@gmail.com ---
Let me just say that I'm very surprised that either of the tables is missing
rows that the other has. Why would userindex suggest that some rows have
been filtered?
--
You are
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #8 from Marc A. Pelletier m...@uberbox.org ---
The rows that are filtered in the _userindex views are where the user id and
user named have been NULLed because of suppression. You'd never *notice* the
missing rows when using
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #9 from Aaron Halfaker aaron.halfa...@gmail.com ---
Marc, as a regular user of this data, that's very unintuitive.
Also:
SELECT COUNT(*) FROM revision_userindex WHERE rev_user IS NULL;
--
You are receiving this mail because:
You
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #10 from Marc A. Pelletier m...@uberbox.org ---
That last paragraph should have ended ... if you are using the revision table,
but mysteriously missing if you are using revision_userindex.
--
You are receiving this mail because:
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #11 from Marc A. Pelletier m...@uberbox.org ---
rev_user may be NULL for reasons /other/ that suppression. :-)
--
You are receiving this mail because:
You are on the CC list for the bug.
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #12 from Marc A. Pelletier m...@uberbox.org ---
(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://bugzilla.wikimedia.org/show_bug.cgi?id=66786
Betacommand phoenixoverr...@gmail.com changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
Aaron Halfaker aaron.halfa...@gmail.com changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
merl bugrepor...@to.mabomuja.de changed:
What|Removed |Added
CC|
https://bugzilla.wikimedia.org/show_bug.cgi?id=66786
--- Comment #3 from Yuvi Panda yuvipa...@gmail.com ---
(In reply to merl from comment #2)
According to doc revisions with suppresed username (by os, steward) )are
currently only available from revision and not revision_noindex.
I think you
14 matches
Mail list logo
