Hide
original bugid: #6877
If you have NULL values in your database, sorting may give odd results.
An ORDERBY query in MYSQL sorts NULL values FIRST.
An ORDERBY query in PostgresSQL sorts NULL values LAST.
This can give odd results when listing data (specifically some fiels, such as dates, where NULL is rendered as 1/1/1970).
Show
original bugid: #6877
If you have NULL values in your database, sorting may give odd results.
An ORDERBY query in MYSQL sorts NULL values FIRST.
An ORDERBY query in PostgresSQL sorts NULL values LAST.
This can give odd results when listing data (specifically some fiels, such as dates, where NULL is rendered as 1/1/1970).