Perhaps not widely encountered, but I came across a potentially unexpected sorting outcome for Entity query builder when testing patches for the menu list builder (see related issues).
Sorted results of execute() function of Drupal/Core/Config/Entity/Query/Query.php are case sensitive. This result may be mitigated by additional alphabetization later on via display. However, when pagination gets activated, due to the result chunking, lowercase entries can end up being grouped together and not displayed where one would expect them.
As soon as pagination is triggered, one should start to see unexpected groupings of lowercase labels on the subsequent page.
Use strcasecmp() when comparing strings.
Test
Review
Commit
None
None
None
None
TBD
Active
10.2 ✨
entity system
We use Composer so adding a patch file for easier local testing.
@tdroden
I have review MR !10909 in Drupal Core 11.x-dev and it's working for me.
So i am moving this issue to RTBC.
Thank you!!