In labsd:
- revision.rev_text_id is 0 while archive.archive_text_id has values - This looks like a sanitization bug (rev_text_id is public and available in dumps).
- archive.ar_comment is set to NULL at view creation [1], while only nullified in revision view according to the deleting flag [2] - I suggest the archive behavior to mimic the revision one.
[1] https://github.com/wikimedia/operations-puppet/blob/production/modules/role/templates/labs/db/views/maintain-views.yaml#L204
[2] https://github.com/wikimedia/operations-puppet/blob/production/modules/role/templates/labs/db/views/maintain-views.yaml#L330