- HeidiSQL version: 11.2.0.6213
- Database type and version: MariaDB 10.4.6
- OS: Windows 10 Pro
Since years I have a table with a DATETIME Field, and only I write to this field, manually, per HeidiSQL (the table is a list, and whenever I solve an entry, I mark it with the current DateTime in the data editor, not with an sql statement). I'm the only person doing that. I always use Heidi for that.
Now I found false, senseless values in this DATETIME column: 3198-04-16 00:00:42, 2955-11-09 28:18:37, 2618-00-01 00:34:33 and so on. And, it get better, I suddenly have a lot of differences between this table and it's replica, in only this field. What can that be?
I thought, maybe it's only a issue with the new heidi version, but old versions show the same wrong values in this column. And of course it could be a serious problem with MariaDB ... but why are replicated values different? Some changes are years old, the replication of this data took place a long time ago, and now, without further changes at this rows, the values are different? But both wrong? And I searched for other DATETIME columns, and there are several, but no one with this "behaviour". And this ist the absolute only column in the database I always change manually with Heidi. I regularly look into this table, several times a week, since a long time. And now I found these false values, only in this column ... the only column I only changed with heidi? I don't understand.
I'm very unsettled right now. I know, it's unlikely, that heidi caused the problem. But only this column of all things?
Is there somebody who can explain what might be happened?