-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Andrew Garrett wrote:
On 9/13/07, Brion Vibber <brion(a)wikimedia.org>
wrote:
1) You can't tell whether the update has been
applied or not
Actually, Simetrical and I discussed this, and we determined that something like
"SELECT 1 FROM pagelinks WHERE pl_namespace=0 AND pl_title='' LIMIT
1;" would work okay, although it's admittedly not ideal.
1) It may detect existing incorrect entries (false positive), thus
failing to apply the update.
2) You'll get a false negative if there are no applicable pages, thus
running the full ugly query unnecessarily.
The update
doesn't really hurt anything if it's run multiple times, either -- the
way the update works is that it will add a bogus entry for any page
with no entries whatsoever (not even bogus ones).
The update is potentially very slow; running it every time update checks
are done would be disruptive to a large site, thus unacceptable.
- -- brion vibber (brion @
wikimedia.org)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org
iD8DBQFG6UhFwRnhpk1wk44RAg6cAJ4lOye0XSFhhHBq3HRNx3JEArCx7QCfY1cv
gzeGFGW7aOBpXXEQ6DO1N1U=
=xWWI
-----END PGP SIGNATURE-----