Bug description

For datasets without temporal columns users can get into a situation where the dataset is no longer useable and needs to be recreated. On a dataset without a temporal column: - select any column as "Is Temporal" - select that column as "Default Datetime" - save the dataset - realize the mistake - update dataset and remove the "is Temporal" checkbox - notice the "default datetime" radio button remains selected and it's not possible to unselect this option

Now all charts built against this dataset will have a default time filter (that can't be removed) on a column that isn't actually temporal. There's no way to get out of this situation without completely recreating this dataset. For datasets with lots of charts built against them this issue becomes very disruptive.

possible fix: the "default datetime" radio button should become unselected if the column is no longer marked as "Is Temporal"

Screenshots/recordings

Screenshot 2024-10-03 at 1 48 22 PM

Superset version

3.1.3

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.
  • [X] 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: rusackas

Heya... is this still an issue in 4.1.2? I was tempted to close out some of these stale 3.x issues, but don't want to if this still needs to be addressed.

Comment From: msyavuz

I can confirm that this is still an issue even in master