Comment 4 for bug 1931626

Demo.evergreencatalog.com is rebuilt from the ground up every weekend. Since the goal is that nothing persists there’s no point in upgrading it. :)

While there are triggers to maintain the symspell entries they're only fired when rows are deleted from the metabib.*_field_entry tables. The aaa_indexing_ingest_or_delete trigger on biblio.record_entry calls biblio.indexing_ingest_or_delete which does remove a couple things when records are deleted, but metabib field entries aren't one of them, regardless of the (poorly named nowadays) ingest.metarecord_mapping.preserve_on_delete global flag.

from a concerto db:
everpost=# select * from metabib.title_field_entry where source =257;
 id | source | field | value | index_vector
-----+--------+-------+------------------+----------------------------------------
 765 | 257 | 6 | Sdílení naděje | 'nadej':4C 'nadeje':2A 'sdileni':1A,3C
 764 | 257 | 53 | Sdílení naděje / | 'nadej':4C 'nadeje':2A 'sdileni':1A,3C
(2 rows)

everpost=# delete from biblio.record_entry where id=257;
DELETE 0
everpost=# select deleted from biblio.record_entry where id=257;
 deleted
---------
 t
(1 row)
everpost=# select * from metabib.title_field_entry where source =257;
 id | source | field | value | index_vector
-----+--------+-------+------------------+----------------------------------------
 765 | 257 | 6 | Sdílení naděje | 'nadej':4C 'nadeje':2A 'sdileni':1A,3C
 764 | 257 | 53 | Sdílení naděje / | 'nadej':4C 'nadeje':2A 'sdileni':1A,3C
(2 rows)