Summary

When running JQL ORDER BY Desc, JIRA places the issue with null value for that field at the highest order, instead of at the lower order. According to the documentation from PostgreSQL 8.3.23 the NULLS FIRST is the default for DESC order, but is configurable.

Steps to Reproduce

1. Having 3 issues with value for a custom field as 1, 2, and null
2. Run JQL query: ORDER BY <cusom_field> Desc

Actual Result

JIRA places the null value at the highest rank
null
2
1

Suggestion

JIRA could order the issues as follows:
2
1
null