As I was writing this, I began to think that this might not be a bug, but I'll explain it anyway just in case you want to prevent a crash. In MySQL, when you set an integer column to display as a UNIX timestamp column and right-click a cell and go to "Insert value" and choose "Unix timestamp", HeidiSQL crashes with the exception message that it's not a valid date/time format. I assume this is because the cell editor being used only works with valid date/time formats since the flag to show the column as a "Unix timestamp" is set? I assume so because choosing "Insert value" and the "Date and time" options works.
BUG: Insert For Unix Timestamp Column.
Yeah and I LOVE it. But since it technically is still an integer column (at least from the database perspective), I made the wrong assumption of choosing to insert the current unix timestamp instead of the current date/time. It's nothing serious and I don't care if it remains how it is since I understand why it's happening now.
Please login to leave a reply, or register at first.