Non-exposed and exposed sorts cause issues with the default sort order

This issue is being reviewed by the kind folks in Slack, #needs-review-queue-initiative. We are working to keep the size of Needs Review queue [2700+ issues] to around 400 (1 month or less), following Review a patch or merge request → as a guide.

Wonder if this is still an issue for D10

Tried replicating in D10 on a standard install
Editing the content view
Add sort for published (ASC) (unexposed)
Add sort for title (exposed)
Add sort for changed date (Exposed)

The sorting appears to be working as expected?

Did I miss a step?

Re-rolled 23 for Drupal 9.5.x.

I was able to replicate the issue on a vanilla Drupal 10 install. See screenshots.

Unexposed DESC sort followed by exposed sort; note that the SQL shows "ORDER BY DESC" for both sorts:

However, the default sort for the exposed filter is actually ASC:

Issue summary is incomplete.

testExposedFilterSortOrder should have return type.

Recommend using MR vs patches as patches are phased out.

ravimane23 → changed the visibility of the branch 9.2.x to hidden.

Added new MR with 11.x branch.

Test coverage appears to have been lost and issue summary update is still needed

kubrick → changed the visibility of the branch 3120847-non-exposed-and-exposed to hidden.

kubrick → changed the visibility of the branch 9.2.x to active.