EntityRepository::getActive does not return a translations most recent revision

How does one suggest an edit to a change record? https://www.drupal.org/node/3036722 has the following

use Drupal\Core\Language\LanguageInterface;
use Drupal\Core\Plugin\Context\Context;
use Drupal\Core\Plugin\Context\ContextDefinition;

// Contextual information can be explicitly specified, a typical example could
// be sending out a notification email containing the node preview.
$contexts = [
  '@language.current_language_context:' . LanguageInterface::TYPE_CONTENT => new Context(new ContextDefinition('language'), 'ro'),
];
$active = $entity_repository->getActive('node', 1, $contexts);

// If the default contextual information needs to be kept, aside from the bits
// being customized, the following code should be used. 
/** @var \Drupal\Core\Plugin\Context\ContextRepositoryInterface $contexts_repository */
$contexts_repository = \Drupal::service('context.repository');
$contexts = $contexts_repository->getAvailableContexts();
$contexts['@language.current_language_context:' . LanguageInterface::TYPE_CONTENT] = new Context(new ContextDefinition('language'), 'ro');
$entity = $this->entityRepository->getActive('node', $value, $contexts);

where

$contexts['@language.current_language_context:' . LanguageInterface::TYPE_CONTENT] = new Context(new ContextDefinition('language'), 'ro');

should be

$language = \Drupal::service('language_manager')->getLanguage('ro');
$contexts['@language.current_language_context:' . LanguageInterface::TYPE_CONTENT] = new Context(new ContextDefinition('language'), $language);

I've edited the change record > https://www.drupal.org/node/3036722.

Some additional notes

I did learn about this new service, which looks to support workspaces, see https://www.drupal.org/node/3036722

When using it though, it does not appear to return the most recent translated revision. For example, when using the following with a node with a pending German and English draft revisions

$latest_revisions = [];
$storage = \Drupal::service('entity_type.manager')->getStorage('node');
$entity = $storage->load(2);
$language_manager = \Drupal::service('language_manager');
$context_definition= new ContextDefinition('language');
$entity_repository = \Drupal::service('entity.repository');
if ($entity instanceof TranslatableInterface) {
  // For each translations load the latest revision.
  foreach ($entity->getTranslationLanguages() as $language) {
    $new_context =  new Context($context_definition, $language_manager->getLanguage($language->getId()));
    $contexts = [
      '@language.current_language_context:' . LanguageInterface::TYPE_CONTENT => $new_context,
      '@language.current_language_context:' . LanguageInterface::TYPE_INTERFACE => $new_context
    ];
    $latest_revisions[$language->getId()] = $entity_repository->getActive($entity->getEntityTypeId(), $entity->id(), $contexts);
  }
}

$latest_revisions['de']->label(); returns the published English revision title.

$latest_revisions['de']->getTranslation('de')->label(); returns the pending draft German revision title.

$latest_revisions['en']->getTranslation('de')->label(); returns the German revision title from node_field_revision associated with the value from $latest_revisions['en']->getRevisionId();

I would expect entity repository getActive() would return the most recent revision so that $latest_revisions['de']->label(); returns the expected German draft revision title.

There does not appear to be a revision context to use with getActive.

I tried to write a test that would express this apparent bug, but either there is no bug or my test isn't written correctly.

I'm going to park this here in hopes to get some eyes on this until I can return to it.

I've updated the issue summary. I've updated the test and uploaded new patch and interdiff. I've added a new related issue #3088341: Add ability to query on most recent language specific revision.

However, while the test passes locally, I still experience the bug using the scenario and code in the issue summary.

So the test failures appear to be related to EntityKernelTestBase usage of entity.manager service, which has been deprecated. Is there something I should do to remedy that?

I'm still looking for feedback to 1) validate the problem in the issue summary and 2) review tests to reproduce the problem.

As I recall, it was a lot of brain work to get into this problem space Best of luck Joseph!