Can't sort table by json data type column with null values

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

Hi @Matthew-Paylode! Thanks for surfacing this to our attention. This is definitely some funky behavior on our end. Our team has created a bug report for this and added you to the report to be notified on fix! :slightly_smiling_face:

Possibly related case:

Just wanted to let you know our team has deployed a fix for table sorting broken for columns with null values. You should see this available for v2.111.0! Thank you again for your feedback! :slightly_smiling_face:

Thank you, Kenny! Looking forward to it!