Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Problem/Motivation
#2950869: Entity queries querying the latest revision very slow with lots of revisions causes sorting problems on postgres and sqlite... fix it.
Steps to reproduce
Run EntityQueryTest
Proposed resolution
Add sort to query
Remaining tasks
User interface changes
None
Introduced terminology
None
API changes
None
Data model changes
None
Release notes snippet
Issue fork drupal-3541487
Show commands
Start within a Git clone of the project using the version control instructions.
Or, if you do not have SSH keys set up on git.drupalcode.org:
changes
Comments
Comment #3
alexpottComment #4
alexpottWe already have sorts on other queries in these tests and we don't guarantee the result of an unsorted query so for me these changes are fine. Also both of these queries were added by #2950869: Entity queries querying the latest revision very slow with lots of revisions and would have failed on Postgres without the change to EntityQuery in that issue.
Comment #5
kim.pepperLooks like a straight forward fix.
Comment #6
alexpottCommitting this so Postgres and SQLite are green again.
Committed and pushed 1b1133d1ff8 to 11.x and 71171df537a to 11.2.x and 23b79dfebd6 to 10.6.x and 1a0d6efea9d to 10.5.x. Thanks!