PostgreSQL: Fix system\Tests\Entity\EntityQueryTest

Created on 1 March 2015, over 9 years ago
Updated 10 May 2023, about 1 year ago

Problem/Motivation

EntityQueryTest fails currently with PostgreSQL as database backend.

Failing test is EntityQueryTest::testSort(). The problem is the way that fields with the value NULL are sorted. MySQL default behavior, the behavior expected by Drupal, is to sort NULL first when in ascending order and last in descending order per its documentation.

Proposed resolution

Update the postgreSQL Select::orderBy() method, so that ascending orderby's order NULL values first and descending orderby's order NULL values last.

Remaining tasks

Write patch.
(Maybe) Create a follow-up feature request to support arbitrary NULL sorting for 8.1.x or 9.0.x???

User interface changes

None.

API changes

None.

πŸ› Bug report
Status

Fixed

Version

8.0 ⚰️

Component
PostgreSQL driverΒ  β†’

Last updated 6 days ago

No maintainer
Created by

πŸ‡©πŸ‡ͺGermany bzrudi71

Live updates comments and jobs are added and updated live.
  • PostgreSQL

    Particularly affects sites running on the PostgreSQL database.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.69.0 2024