The attached branch re-checks messages in Hardy and later for gettext errors when given the selection clause:
is_current IS TRUE AND id >= 74539159 AND EXISTS (
SELECT * FROM POTMsgSet
WHERE
POTMsgSet.sequence > 0 AND
POTMsgSet.id = TranslationMessage.potmsgset AND
flagscomment LIKE '%format%'
)
Took just under 6 hours on staging, of which about 24 minutes were spent collecting the TranslationMessages. It may be advisable to break it down into chunks.
The attached branch re-checks messages in Hardy and later for gettext errors when given the selection clause:
is_current IS TRUE AND id >= 74539159 AND EXISTS ( .sequence > 0 AND age.potmsgset AND
SELECT * FROM POTMsgSet
WHERE
POTMsgSet
POTMsgSet.id = TranslationMess
flagscomment LIKE '%format%'
)
Took just under 6 hours on staging, of which about 24 minutes were spent collecting the TranslationMess ages. It may be advisable to break it down into chunks.