HeidiSQL 9.4.0.5125 crash with EAccessViolation

[expired user #11096]'s profile image [expired user #11096] posted 6 years ago in General Permalink

I managed to crash HeidiQSL 9.4.0.5125 with an EAccessViloation by modifying a table and switching from 'Table' to 'Data' view.

Environment: Windows 10, 64-bit talking to MySQL 5.7 on Ubuntu 16.04 LTS server over standard TCP/3306 connection.

I added a new column 'active' (TINYINT) in table view, clicked the data tab to switch to the data view which was displayed but without the new column (I had already been editing data previously).

I expected to right-click and 'Refresh' to see the new column by HeidiSQL threw an error message:

SQL Error (1364): Field 'active' doesn't have a default value

and when I hit 'Ok' it crashed.

Bug report attached.

Regards

Mike

1 attachment(s):
BubikolRamios's profile image BubikolRamios posted 6 years ago Permalink

That is coz you 1.entered/edited data --> not saved it ! 2. addec column 3. refresh on data view triggers save, and can't save coz of

SQL Error (1364): Field 'active' doesn't have a default value

Please login to leave a reply, or register at first.