On 9/13/07, Brion Vibber brion@wikimedia.org wrote:
- 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. 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).