Group results is different between MySQL and PostgreSQL
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?
PostgreSQL-MySQL-NULL.png (94.8 KB)
Can you report a ticket, please?
Thank you for the reply. Sure. So I just created a ticket. #32404
Hope it makes sense to you.