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 about 3 years ago
- Status changed from New to In Progress
- Priority changed from New to Priority14
#2 Updated by Andreas Müller about 3 years ago
- Status changed from In Progress to Resolved
Fixed by r28664
#3 Updated by Andreas Müller about 3 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 almost 3 years ago
- Description updated (diff)
- Status changed from Resolved to Closed
- % Done changed from 0 to 100
#5 Updated by Andreas Müller almost 3 years ago
- Private changed from Yes to No
