[BUG] Duplicate row ignores empty columns

Hello, i have a table with a varchar column (not null, no default defined).

The table contains a row with an empty string in that column.

If i duplicate the row and do not change that column i get "SQL 1364: column does not have a default value".

Andi

You should post the version of HeidiSQL you are using (or even better, ensure you're on the latest build), and then please post the INSERT query fired internally by HeidiSQL.

Version: 9.4.0.5141

INSERT INTO schema.table (did, aid, checkboxtext, buttontext) VALUES ('1716', '1', 'xx', 'xx'); / SQL Fehler (1364): Field 'bestaetigungstext' doesn't have a default value /

Workaround: insert ' ' and update INSERT INTO schema.table (did, aid, bestaetigungstext, checkboxtext, buttontext) VALUES ('1716', '1', ' ', 'xx', 'xx');

UPDATE schema.table SET bestaetigungstext='' WHERE mdaid=1075;

Can you reproduce the bug or do you need more information?

No, I can confirm the issue. Quite easy to work around though, by putting some string the relevant field manually. But I'll check why Heidi does not show the red "modified" triangle on such a field when duplicating a row.