I have a query that returns records; some have json values, the rest are null.
The problem is that the table sort column functionality doesn't seem to work on that column. In other words, sorting asc or desc on that column doesn't have the expected outcome. I would expect null values to either be first or last, but that doesn't happen.
The screenshot illustrates what happens when attempting to sort in desc order. You can see that the rows with values and with null values don't seem to have any sort applied to them (or, if it does, the method is unclear).
What I've tried (to no effect):
- Refreshing the page
- Removing sort from column, then reapplying
- Change column type from Auto to JSON