bug #5826
Clean up names with empty name descriptions
Start date:
07/08/2016
Due date:
% Done:
100%
Severity:
normal
Found in Version:
Description
As described in #5638 many empty NameDescriptions have been created in the past. These should be deleted from the database.
Associated revisions
#5826 Clean up names with empty name descriptions
ref #5826 adapt update script
History
#1 Updated by Andreas Müller over 4 years ago
- Status changed from New to In Progress
- Priority changed from New to Priority14
#2 Updated by Andreas Müller over 4 years ago
- Status changed from In Progress to Resolved
Fixed by r28664
#3 Updated by Andreas Müller over 4 years ago
Some SQL statements for testing
SELECT db.id, dba.DTYPE, dba.feature_id, db.created FROM DescriptionBase db INNER JOIN DescriptionElementBase dba ON dba.indescription_id = db.id WHERE db.DTYPE = 'TaxonNameDescription' AND EXISTS (SELECT * FROM DescriptionElementBase deb WHERE deb.indescription_id = db.id AND deb.id NOT IN (SELECT id FROM DescriptionElementBase deb WHERE deb.feature_id = 952 )); SELECT * FROM DefinedTermBase dtb WHERE dtb.titleCache like '%Protolo%' OR id = 953; SELECT * FROM DescriptionElementBase deb WHERE deb.feature_id = 952; SELECT * FROM DescriptionBase db WHERE db.DTYPE = 'TaxonNameDescription' AND NOT EXISTS (SELECT * FROM DescriptionElementBase deb WHERE deb.indescription_id = db.id );
#4 Updated by Andreas Müller about 4 years ago
- Description updated (diff)
- Status changed from Resolved to Closed
- % Done changed from 0 to 100
#5 Updated by Andreas Müller about 4 years ago
- Private changed from Yes to No