Bug description

When viewing charts, if you try to sort by last modified, not all dates returned are sorted in order.

How to reproduce the bug

  1. Go to the chart list page making sure you have charts that have different modified dates so they don't all belong to the same day
  2. Click on the sort by last modified in the header
  3. Notice in the column that some of the last modified dates are out of order.

Screenshots/recordings

Screenshot 2024-03-13 at 10 12 28 AM

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

Checklist

  • [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
  • [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
  • [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

Comment From: michael-s-molina

@sadpandajoe I think this a problem with our example charts that are loaded with NULL values for the last_saved_at column. Are you able to reproduce this using non-example charts?

Comment From: sadpandajoe

@sadpandajoe I think this a problem with our example charts that are loaded with NULL values for the last_saved_at column. Are you able to reproduce this using non-example charts?

Yeah this was part of our prod instance that I threw the head of 4.0 branch onto.

Comment From: rusackas

It seems like this is also happening with non-example charts, even on the latest master or Preset. @sadpandajoe hit me up if you want to take a look more synchronously.

Comment From: rusackas

Can anyone confirm this is still happening in 4.1.2?

Comment From: rusackas

@sadpandajoe this still happening?