An empty fullTitleCache with atomized data was not found anywhere. Empty fullTitleCaches exist for fully empty data which have something like TaxonName#9617 in the titleCache. So empty fullTitleCaches are not replaced by this default yet. But maybe this is also not necessary.
Only in algaterra_old I found records with also empty titleCache which needs to be further checked. Even after running cacheUpdate and trying to edit the names manually.
SELECT id, protectedTitleCache, protectedFullTitleCache, titleCache, fullTitleCache , tn.*
FROM TaxonName tn
WHERE tn.titleCache IS NULL OR tn.titleCache = '' OR tn.fullTitleCache IS NULL OR tn.fullTitleCache = ''
;
SELECT *
FROM OriginalSourceBase osb
WHERE osb.sourcedName_id IN (
SELECT id
FROM TaxonName tn
WHERE tn.titleCache IS NULL OR tn.titleCache = '' OR tn.fullTitleCache IS NULL OR tn.fullTitleCache = ''
) ;
Also in Flora Malesiana after running cache update (#9650).
Pro-iBiosphere eupolybothrus_pilot has empty titleCache with atomized data but this has no CDM Server anymore and was not yet cache updated. => the DB is archived in the meanwhile.
Also rl_standardliste has them but was not yet cache udpated. => do not exist anymore after cache updating (#9650)