Updating this bug with some slightly newer SQL for 2.6+ systems:
-- This tells you how many bibs are affected:
SELECT COUNT(*) FROM biblio.record_entry WHERE deleted = FALSE AND id NOT IN (SELECT source FROM metabib.record_attr_vector_list);
-- This tells you exactly which bibs are affected, by bib ID:
SELECT bre.id FROM biblio.record_entry bre LEFT JOIN metabib.record_attr_vector_list mravl ON mravl.source = bre.id WHERE bre.deleted = FALSE AND bre.active = TRUE AND mravl.vlist IS NULL;
Updating this bug with some slightly newer SQL for 2.6+ systems:
-- This tells you how many bibs are affected: record_ attr_vector_ list);
SELECT COUNT(*) FROM biblio.record_entry WHERE deleted = FALSE AND id NOT IN (SELECT source FROM metabib.
-- This tells you exactly which bibs are affected, by bib ID: record_ attr_vector_ list mravl ON mravl.source = bre.id WHERE bre.deleted = FALSE AND bre.active = TRUE AND mravl.vlist IS NULL;
SELECT bre.id FROM biblio.record_entry bre LEFT JOIN metabib.