Can't sort column if the same one is being mentioned in a ORDER BY clause - JQL - Jira Issue Macro

Summary

If you add a ORDER BY clause on the JQL of a JIRA Issue/Filter, you won't be able to change the sort of the column through the UI.

Steps to Reproduce

1. Create a project in JIRA with 5 tickets.
2. Go to a Confluence page and insert a JIRA Issue Macro.
3. On the Search field, add the following filter:

   project = <project> order by Key  
   

   The Key field is default.

4. Save the page.
5. The JIRA Issue Macro is displaying all issues ordered by the Key column.
6. Try to sort the Key field manually by clicking on it.

Expected Results

The Key column will change the sort.

Actual Results

The below exception is thrown in the UI:

JIRA project doesn't exist or you don't have permission to view it.
View these issues in JIRA

Notes

1. Adding the filter:
   
2. After saving the filter:
   
3. Error after trying to sort the column mentioned in the ORDER BY:
   

It looks that the ORDER BY locks the column.

Workaround

Remove the Order by clause.