PostTags table in SEDE does not contain deleted posts. For example, on Worldbuilding:
- Nondeleted posts: Total: 10845, In PostTags: 10845 (100.00%)
- Deleted posts: Total: 1410, In PostTags: 2 (0.14%)
This doesn't seem to make sense because:
PostsWithDeleteddoes exist, to give us some info about deleted posts.
PostsWithDeleted.Tagsis not sanitized, implying that it's acceptable and desirable to have the tags of deleted posts exposed.
- Note that every question in
PostsWithDeletedhas a non-null, non-empty
Tagsfield, which I verified as a sanity check.
So basically, we do have access to information about the tags of deleted posts (via
PostsWithDeleted.Tags), but, unlike non-deleted posts, we're stuck with no good way to process that information (as
Tags is just a string of tag names enclosed in angle brackets).
PostTags should include deleted post tags to be consistent with
PostsWithDeleted and allow consistent access to tag information. Alternatively,
PostTagsWithDeleted could be added.
I primarily consider this a bug due to the inconsistency which does not seem reasonably intentional (why present the information in
PostsWithDeleted.Tags without giving
PostTags-style access to it?), and it's a usability issue. However, this could also be considered a feature request. For now I've tagged as both.