ContentEntityStorageBase::getLatestRevisionId() returns empty value

The problem

• Say, you have a node which can be translated to Eng (default language) and Fre.
• I could not reproduce the exact steps, but sometimes, the node_field_data ends up in such a state that ContentEntityStorageBase::getLatestTranslationAffectedRevisionId($entity_id, $langcode) returns an empty value
• As a result of this, ModerationInformation::hasPendingRevision() cannot load the $latest_revision.
• Since $latest_revision cannot be loaded, it then ends up calling $latest_revision->wasDefaultRevision on NULL; This results in a WSOD when editors try to edit the node in the language which has node_field_data.revision_translation_affected = NULL.

Question 1

So, my question is, possible to have the node_field_data table in the following state:

+-----+------+---------+----------+--------+-----------------------------------+-----+------------+------------+------------------+
| nid | vid  | type    | langcode | status | title                             | uid | created    | changed    | default_langcode |
+-----+------+---------+----------+--------+-----------------------------------+-----+------------+------------+------------------+
| 781 | 4432 | article | en       |      1 | Différé EN29 janvier              |   0 | 1548799632 | 1549314390 |                0 |
| 781 | 4432 | article | fr       |      1 | Différé FR 29 janvier - Revised   |   0 | 1548799632 | 1549472245 |                1 |
+-----+------+---------+----------+--------+-----------------------------------+-----+------------+------------+------------------+

Question 2

If the above state of the tables is normal, then it is also normal for ContentEntityStorageBase::getLatestTranslationAffectedRevisionId() to return an empty value. In that case, I'd like to propose the patch I'll be posting in comment 1.