Project

General

Profile

Group results is different between MySQL and PostgreSQL

Added by Simon Hori over 4 years ago

Recently we've migrated over 1 million issues from MySQL to PostgreSQL.
And noticed a difference when users use Group results by function on Issues page.
As you see in the screenshot, MySQL shows (blank) group first but PostgreSQL shows (blank) group last.

Is it possible to adjust (blank) appears on the top with PostgreSQL?

I guess it is because `NULLS LAST` is the default for ASC order in PostgreSQL.
Can we enforce `NULLS FIRST` in the SQL query to postgres?
https://www.postgresql.org/docs/8.3/queries-order.html


Replies (2)

RE: Group results is different between MySQL and PostgreSQL - Added by Simon Hori over 4 years ago

Thank you for the reply. Sure. So I just created a ticket. #32404
Hope it makes sense to you.

    (1-2/2)