Problem when altering columns

[expired user #574]'s profile image [expired user #574] posted 18 years ago in General Permalink
Hi !

I discovered a problem where HeidiSQL does not recognize the changed properties of an altered column.

How to reproduce:

- Testtable with a column "xxx", data type varchar(10).
- Enter 10 characters of text in the data view.
- Alter table, change varchar(10) to varchar(20)
- Change back to data view and try to enter more characters

At this point HeidiSQL still limits the max length of the column to 10 chars.

If you close and re-open HeidiSQL all is fine and you are able to enter 20 chars.

Perhaps the program should re-read the table properties after altering it. Anyway it is a nice program :-)

Greetings, Dirk
ansgar's profile image ansgar posted 18 years ago Permalink
That topic is related to this issue in our tracker: http://sourceforge.net/tracker/index.php?func=detail&aid=1704044&group_id=164593&atid=832347

There will be no simple solution on HeidiSQL's side. Refreshing the datagrid is an incredible easy workaround for that, but I'm not sure if there are more simple ideas how to make that more comfortable.

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