GetWorkflow doesn't find archived one

Expected Behavior

When passing both a workflow and run ID, the SDK should return the desired run for the given workflow, even though this workflow has been archived, right?

So this code should work:

wr := c.GetWorkflow(context.Background(), WorkflowId, RunId)
err = wr.Get(context.Background(), &ptr)
if err != nil {
  // ...
}

Actual Behavior

But when executing this, I have the following error:

Workflow executionsRow not found.  WorkflowId: <id>, RunId: <id>

It looks like the error comes from temporalio/temporal/blob/master/common/persistence/sql/execution.go#L257

Steps to Reproduce the Problem

1. Run a workflow, and wait for it to be archived.
2. With the SDK, get the workflow by passing its ID and a run ID.

(I use the file storage for archival, which works fine.)

Specifications

• Version: SDK v1.8.0, Server v1.11.2
• Platform: darwin

Start at common/persistence/sql/execution.go around line 257 and trace the GetWorkflow path used with both WorkflowId and RunId. Reproduce the case after a workflow is archived, then verify that the SDK returns the requested archived run instead of the “Workflow executionsRow not found” error.