Project

General

Profile

Forums » Open discussion »

Group results is different between MySQL and PostgreSQL

Added by Simon Hori about 5 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

PostgreSQL-MySQL-NULL.png (94.8 KB) PostgreSQL-MySQL-NULL.png

Replies (2)

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

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

    (1-2/2)